none
Torn page in modellog.ldf RRS feed

  • Question

  • Server running SQL server 2000 crashed due to power loss - on restart could not start sqlserver - received error torn page in modellog.ldf

    Any suggestions on how to recover would be appreciated

    Ray

    Wednesday, September 22, 2010 1:40 PM

Answers

  • Swap the physical file either from backup or from any other server having same build.

    remember model is a template for new databases (incl tempdb).

     

    Wednesday, September 22, 2010 1:42 PM
    Answerer
  • ... and, I forgot, same collation.
    Tibor Karaszi, SQL Server MVP | web | blog
    Thursday, September 23, 2010 4:47 AM
    Moderator

All replies

  • Swap the physical file either from backup or from any other server having same build.

    remember model is a template for new databases (incl tempdb).

     

    Wednesday, September 22, 2010 1:42 PM
    Answerer
  • Thank you problem solved
    Wednesday, September 22, 2010 2:23 PM
  • Do you have a backup of the model database? IF not, then see if you have any other SQL Server of same version and build number from where you can pick up the db files or SQL Server backup of the database. Or, see if any of the traceflags 3607, 3608, 3609 might be helpful (Search the net and read about what each do).
    Tibor Karaszi, SQL Server MVP | web | blog
    • Proposed as answer by Lekss Wednesday, September 22, 2010 11:52 PM
    Wednesday, September 22, 2010 2:24 PM
    Moderator
  • Yes TiborK is right , start your SQL server with trace flag 3608 and this will recover only master database during startup , now use your backup or logfile from other model database from anyother server potentially running the same version , service pack of SQL server.
    Thanks, Leks
    Thursday, September 23, 2010 12:17 AM
  • ... and, I forgot, same collation.
    Tibor Karaszi, SQL Server MVP | web | blog
    Thursday, September 23, 2010 4:47 AM
    Moderator