Rarely I need to perform detach/attach stuff during my development. However, I have to develop an application that use sql server user instance (I am not sure I call it right) this recently.
My problem is each time I detach .mdf file from one machine located at, say: D:\Data\Db.mdf. Once after I trasfer this file to other machine at: C:\Db.mdf, then I try to attach this .mdf file. What cause the problem here is sql server doesn't allow me to attach the file unless I have the .mdf file corresponding .ldf file.
My thought is that sql server should allow me to attach the file and create a .ldf file if it doesn't find one. Any idea why this happen?