This one's related to posthttp://forums.asp.net/1210138/ShowPost.aspx
The LDF is the log file (containing transaction logs) for the .mdf. I believe you need both to do the attach, and they should always be together in the directory structure. You should be able to get the .ldf from the same place you got the .mdf. If your database is called mydata.mdf then the transaction log will be called mydata_log.ldf
|||I believe someone was looking for something similiar a month or a two ago, and they did find a solution, you may try searching the forums. Unfortunately, I don't remember what they did ;-(|||
Freakyuno wrote:
The LDF is the log file (containing transaction logs) for the .mdf. I believe you need both to do the attach, and they should always be together in the directory structure. You should be able to get the .ldf from the same place you got the .mdf. If your database is called mydata.mdf then the transaction log will be called mydata_log.ldf
Normally the .ldf must accompany the .mdf file, I know but in this case, the Atlas Wiki starter kit doesn't ship with the .ldf files.|||
If I only have a .mdf file available, how can I attach it to SQL Server 2005? It keeps asking for a .ldf file which I don't have.
Hi,
you can use the Microsoft SQL Management studio, choose the Master database in the combobox, open up a new query window and use the
sp_attach_single_file_db
command to get it to work.
Grz, Kris.
|||Thanks, that seemed to do the trick.
No comments:
Post a Comment