Home Forums Article Discussions Article Discussions by Author Discuss content posted by Phil Factor The first thing to do with a damaged off-line database RE: The first thing to do with a damaged off-line database

  • 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.