ajpolew.blogg.se - Rebuilding master database in sql server

Note: this exercise was performed on SQL Server 2005, but the same rules would also be applied on SQL Server 2005 and onwards. In the next sections we will go through the restore process for the msdb and model databases. The restore process of msdb or model demands additional considerations than that of a user databases. The restore process may get complicated if versions are not tracked and exclusive access is not ensured in all aspects. Hence both the msdb and model databases may need to be recovered in scenarios like database corruption, a rebuild of the master database or after a new server configuration. If the model database has been modified then it should be backed up. DBAs can modify the model database with whatever settings that are required and when a new user database is created it will reflect the configuration of the model database.

The model database is the blue print for creating any new user database for that particular instance of SQL Server.

The msdb database contains scheduled jobs, alerts and backup history therefore a proper backup plan should be implemented for the msdb system database.

Before we get started, let's quickly discuss what the msdb and model databases are used for.