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