•DISK MIRROR
•DISK UNMIRROR
•DISK REMIRROR
•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.
CAUTION: You must rebuild using the same character set and sort order as the master database dump that will be reloaded
To recover a damaged master database:
2.Restart Microsoft SQL Server in
3.Restore the master database from the most recent backup
4.Apply changes to the master database
5.Drop invalid databases and database devices
Each of these steps is described below in more detail:
Rebuild the master database
1.From Windows Explorer select Start→Programs→Microsoft SQL Server, and then select the SQL Setup icon.
(Alternatively, from the distribution media, from the directory containing the software compatible with your hardware platform’s processor architecture, run SETUP.EXE.)
2.Respond to the
3.Select Rebuild Master Database and click Continue. A confirmation window appears.
4.Click Resume. The Rebuild Options window appears.
5.To specify the character set, click Sets and complete the Select Character Set window that appears. Skip this step if you are using the default character set (ISO
NOTE: You must use the same character set and sort order that were previously used for this master database.
6.To specify the sort order, click Orders and complete the Select Sort Order window that appears. Skip this step if you are using the default sort order (dictionary order,
7.In the Rebuild Options window, click Continue. The SQL Server Installation Path window appears.
Working with Microsoft SQL Server 59