System Database Backup - SQL-FineBuild/Common GitHub Wiki

This process will take a copy of critical system databases. If there is ever a corruption of these databases the copy saved in this process provides a route for recovery that can get SQL Server working again quickly.

This process will take a copy of the master, mssqlsystemresource and distmdl databases. The model and msdb databases are not included in this backup because they are more easy to recover.

If either the master or mssqlsystemresource databases have to be recovered, both database should be recovered. It is important that the internal version number of these two databases always matches. If you do have to recover the master database from this backup, you will need a manual process to add back into the master database any changes (such as SQL Logins) that were added to master after the backup was taken.

This process is performed automatically by SQL FineBuild. The steps below show what steps are performed.

  1. Stop SQL Server using the appropriate command from the table below:

    Type of SQL Server install Command
    SQL Server not clustered, default instance NET STOP MSSQLSERVER
    SQL Server not clustered, named instance NET STOP MSSQL$name
    SQL Server is clustered CLUSTER ClusterName GROUP SQLClusterGroup /OFF

  2. Copy the files listed to the destination system database backup folder

    The destination folder is at drive:\SQLFiles\MSSQL.MSSQLSERVER.Backup\SystemDataBackup

    The distmdl may not exist for all SQL Server installations

    Folder File
    drive:\MSSQL\MSSQLSERVER\data master.mdf
    mssqlsystemresource.mdf
    distmdl.mdf
    drive:\MSSQL\MSSQLSERVER\log mastlog.ldf
    mssqlsystemresource.ldf
    distmdl.ldf

  3. Start SQL Server using the appropriate command from the table below:

    Type of SQL Server install Command
    SQL Server not clustered, default instance NET START MSSQLSERVER
    SQL Server not clustered, named instance NET START MSSQL$name
    SQL Server is clustered CLUSTER ClusterName GROUP SQLClusterGroup /ON

Use the Browser BACK button to return to the parent process

Top

Copyright FineBuild Team © 2014 - 2021. License and Acknowledgements

⚠️ **GitHub.com Fallback** ⚠️