7/16/2015 10:12:45 AM
Viewed: 813
tamkhong
2/5/2013 4:59:47 PM
Attach Database Without a Transaction Log File in SQL Server ( Attaching MDF without LDF )

Maybe you should try this. I got the answer from an MSDN thread.

  • make a copy of your mdf file and change the extention (.mdf) to (.ldf)
  • attach the mdf file using SSMS (note you have to locate the .ldf file)
  • if you click ok ( error will occur) thats normal.
  • select the ldf file and click remove. SQL server will automatically create a new ldf file for your attached mdf file.
  • click OK now and your done..

Gửi trả lời