Post reply

backup for system database

  • December 9, 2011 at 5:25 am

    #248000

    should i take scheduled backup for the system database, and what is the advantages?

  • December 9, 2011 at 5:40 am

    #1419237

    Simple answer: Yes.

    Advantages: You will be able to recover critical info such as Logins, Jobs, configuration.

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

  • December 9, 2011 at 5:43 am

    #1419239

    which types of backups will be perform, and what is strategy for all sys db

  • December 9, 2011 at 5:46 am

    #1419240

    Strategy is simple - regular full backups so that when/if something happens, you don't have to recreate your logins, permissions, settings, jobs, SSIS packages, job history, backup history from scratch.

    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

  • December 9, 2011 at 5:49 am

    #1419242

    Dhirju (12/9/2011)

    which types of backups will be perform, and what is strategy for all sys db

    Considerations for Backing Up the master Database

    http://msdn.microsoft.com/en-us/library/ms191488.aspx

    Considerations for Backing Up the model and msdb Databases

    http://msdn.microsoft.com/en-us/library/ms188274.aspx

  • December 9, 2011 at 5:52 am

    #1419245

    thanks 2 all 😀

Viewing 6 posts - 1 through 5 (of 5 total)

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