Post reply

When do we need to restore the system databases?

  • October 30, 2008 at 4:54 pm

    #195487

    Hi,

    According from the Maintenance Plan, all the databases are backing up every night including Master, Model, Pub, Tempdb and so on.

    I understand about the model database, that is for DTS packages. What about the others? When do we need to restore those databases?

    Thanks.

  • October 31, 2008 at 2:50 am

    #892196

    When the drive that they're on fails.

    Model is not for DTS packages. Model is the template for creation of any other database (including tempDB when it gets recreated). MSDB is the database that stores dts packages, jobs and backup hostory.

    Pubs is a sample database and shouldn't be installed at all on a production system. Same goes for northwind.

    You can't backup TempDB. Trying will throw an error.

    You should backup master, model and msdb, plus all of your user databases

    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

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply