The first thing to do with a damaged off-line database

• Ken

  SSCoach

  Points: 17191

  More actions

  July 21, 2014 at 10:53 am

  #1731094

  Nice question and very timely for me. We have had a lot of DR discussions lately. 🙂

• Revenant

  SSC-Forever

  Points: 42467

  More actions

  July 21, 2014 at 3:43 pm

  #1731239

  I learned something. Thanks, Phil!

• Hardy21

  SSCrazy Eights

  Points: 9708

  More actions

  July 22, 2014 at 2:37 am

  #1731334

  Revenant (7/21/2014)

  ---

  I learned something. Thanks, Phil!

  +1

  Thanks

• Raghavendra Mudugal

  SSChampion

  Points: 10658

  More actions

  July 24, 2014 at 9:54 am

  #1732139

  Something related to Tail-Log Backup (just came across it)

  MSSQL SP2

  Link; http://support.microsoft.com/kb/2958429

  KB 1184332

  "If a tail log backup is performed against the model database, model database will freeze in restoring state during a server restart that will prevent the SQL Server from starting successfully. This is because Tempdb database could not be created during the server startup and you receive the following error message: “Database '<DatabaseName>' cannot be opened" "

  ww; Raghu
  --
  The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.

• rhythmk

  SSCertifiable

  Points: 7271

  More actions

  July 28, 2014 at 5:09 am

  #1732756

  Thanks for question.

  --rhythmk
  ------------------------------------------------------------------
  To post your question use below link
  
  https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help
  🙂