
306
Data Protector Express® User’s Guide and Technical Reference
The most common statements and system procedures that modify master are:
•
DISK INIT
•
CREATE DATABASE
•
ALTER DATABASE
•
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. Because of this,
always dump (back up) the master
database after creating, expanding or shrinking user databases.
To recover a damaged master database
1. Use the SQL Setup program to rebuild the master database.
You must rebuild using the same character set and sort order as the master database dump that will be
reloaded.
2. Restart SQL Server in single-user mode.
3. Restore the master database from the most recent backup.
4. Apply to the master database any changes that were not included in the most recent backup.
5. Drop any databases from the newly restored master database.
6. Restore the msdb database.
Each of these six steps is described below in more detail:
Step 1. Rebuild the master database
1. From Windows Explorer select Start, Programs, Microsoft SQL Server, 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 on-screen instructions until the Options window appears.
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 8859-1).
Summary of Contents for BB118BV - StorageWorks Data Protector Express Package
Page 1: ...U s e r s Gu i d ea n dT e c h n i c a l R e f e r e n c e ...
Page 339: ......
Page 345: ......
Page 365: ...Index 347 ...