![]() ![]() ![]() If the master database is corrupted or damaged, SQL Server won't start. Modifying any server or database-configuration optionsīecause the msdb database holds a record of all backups, back up the master database and then the msdb database.Modifying security by adding logins or changing roles.You back up the master database in the same manner as user databases.īe sure to back up the master database when doing any of the following: Using only full backups for the master database is OK it's not a transactional database. The master database, by default, uses the simple recovery model. A complete recovery plan must include the system databases. The master database contains key database and security information, and the msdb database holds the schedules and jobs for SQL Server, as well as the backup history. So far, this chapter has dealt only with user databases, but the system databases are important to the recovery operation as well.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |