how to restore DB with only MDF

• lazy writer

  Ten Centuries

  Points: 1126

  More actions

  January 9, 2010 at 8:09 am

  #144076

  Hi friends..

  As part of rebuilding the sql server, I could find one of my user DB's .ldf was corrupted so can you help me to restore the DB properly.

  Thanks in advance.

  Kris

• Dugi

  SSCoach

  Points: 17998

  More actions

  January 9, 2010 at 9:41 am

  #1101397

  Try this locations for your case...

  http://www.sqlservercentral.com/Forums/Topic646802-146-1.aspx

  or

  http://social.msdn.microsoft.com/Forums/en/sqldisasterrecovery/thread/189be01f-23de-48b0-96cc-8f1292c13c54

  ============================================================
  SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
  http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

• Gail Shaw

  SSC Guru

  Points: 1004504

  More actions

  January 9, 2010 at 11:16 am

  #1101413

  Step 1, restore a good backup. If you don't have a backup (why not) try CREATE DATABASE ... FOR ATTACH_REBUILD_LOG

  If that doesn't work, check out the steps here: http://sqlinthewild.co.za/index.php/2009/06/09/deleting-the-transaction-log/

  Gail Shaw
  Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
  SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

  We walk in the dark places no others will enter
  We stand on the bridge and no one may pass

• lazy writer

  Ten Centuries

  Points: 1126

  More actions

  January 11, 2010 at 6:20 pm

  #1102123

  Thanks Gail.. Good Stuff.