Recovery of a Corrupt Log File

• bigdave

  SSC Eights!

  Points: 853

  More actions

  September 3, 2002 at 6:38 pm

  #57956

  A client of mine has a corrupt log file, and hence a suspect database. Problem is that the database has two log files - so I think that attach will not work.

  In previous posts it was mentioned that there is a work around for this scenario - but no details were given.

  It is SQL 7.0

  Can someone please help me recover this database?

  Thanks

  BigDave

• Andy Warren

  SSC Guru

  Points: 119902

  More actions

  September 4, 2002 at 5:13 am

  #435896

  I tested on SQL2000, I think changes required for SQL7 but I think concept might still work! I'd suggest making a backup of master at the very least before trying it.

  http://www.sqlservercentral.com/columnists/awarren/attachanddetachagain.asp

  Andy

  http://www.sqlservercentral.com/columnists/awarren/

  Andy
  SQLAndy - My Blog!
  Connect with me on LinkedIn
  Follow me on Twitter