
Appendix H - Working with Microsoft SQL Server
309
restore any databases contained on the database device until the file is restored or the database device is
dropped. If the database device is dropped, Data Protector Express will automatically recreate the device
when a database contained on the device is restored.
Step 6. Restore the msdb database
Refer to
Restoring SQL Server User Databases
earlier in this appendix for specific information on
restoring SQL Server databases.
When restoring the msdb database, keep the following considerations in mind:
•
The msdb database supports SQL Executive and provides a storage area for scheduling information.
The schedules that you implement using SQL Enterprise Manager are maintained in the msdb
database. This includes such things as the tasks that you schedule from the Task Scheduling window,
the automatic backups you schedule from the Database Backup/Restore window and all replication
tasks, which are automatically created by the system if the server is configured as a replication
distributor.
•
During installation of a server, the setup program automatically creates two devices (of 2MB and
1MB) on the same disk drive as the master database and then places the msdb database on the 2MB
device (MSDBDATA) and its transaction log on the 1MB device (MSDBLOG). Scheduling
information is then stored in this database.
•
During a rebuild of the master database, the setup program drops and re-creates the msdb database,
which results in a loss of all scheduling information.
Содержание BB118BV - StorageWorks Data Protector Express Package
Страница 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 ...
Страница 339: ......
Страница 345: ......
Страница 365: ...Index 347 ...