![]() 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.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |