being aware of the statements and system procedures, and the equivalent actions in SQL Enterprise Manager, that modify it.
The most common statements and system procedures that modify master are:
•CREATE DATABASE
•ALTER DATABASE
•sp_dropremotelogin
•sp_addumpdevice
•sp_dropdevice
•sp_addlogin
•sp_droplogin
•sp_addserver
•sp_dropserver
•sp_addremotelogin
If a user database is created, expanded or shrunk after the most recent dump (backup) of the master database and if it becomes necessary to reload the master database, then that user database and all data in will be lost and must be restored from backup.
CAUTION: Because of this, always dump (back up) the master database after creating, expanding or shrinking user databases.
To recover a damaged master database:
1.Stop the Data Protector Express and SQL Server services
2.Rebuild the master database
3.Restart SQL Server in
4.Restore the master database from the most recent backup
5.Apply changes to the master database. Apply any changes that were not included in the most recent backup.
6.Drop invalid databases. Drop invalid databases from the newly restored master database.
7.Start the Data Protector Express and SQL Server services
8.Restore the msdb database
Each of these steps is described below in more detail.
Stop the Data Protector Express and SQL Server services
1.Exit Data Protector Express.
Working with Microsoft SQL Server 55