This project has moved and is read-only. For the latest updates, please go here.

System Database Backup

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 distmdl may not exist for all SQL Server installations.
The destination folder is at drive:\SQLFiles\MSSQL.MSSQLSERVER.Backup\SystemDataBackup
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

Copyright © 2014 Edward Vassie. License and Acknowledgements

Last edited Oct 31, 2014 at 6:07 PM by EdVassie, version 1