The following topics describe the prerequisites and procedures for restoring system databases:
After the failure of your SQL Server system databases (distribution, master, tempdb, model, and msdb databases), you can restore them from SnapManager backup sets for default and named SQL Server instances.
Before you can restore system databases from SnapManager backup sets:
The procedure to restore your SQL Server system database depends on whether the database is still functional. If the database is no longer functional, you will need to rebuild the system databases first.
If you are restoring system databases that are still functional, you only need to use SnapManager to restore the system databases from SnapManager backup sets.
For more information, see Chapter 10, Restoring Databases Using SnapManager.
If you are restoring system databases because they are no longer functional, you must first rebuild the system databases using an SQL Server utility:
For more information, see your Microsoft SQL Server 2000 documentation.
For more information, see your Microsoft SQL Server 2005 documentation.
To rebuild and then restore SQL Server system databases from SnapManager backup sets, complete the following steps.
| 1 |
Create a new Data ONTAP LUN on the same drive letter as the original LUN. |
| 2 |
Use Rebuildm.exe or setup.exe to create base system databases. For more information, see your SQL Server 2000 or 2005 documentation. Result |
| 3 |
Migrate the system databases from the default location back to the Data ONTAP LUN. For more information, see Migrating SQL Server databases to LUNs. |
| 4 |
Use SnapManager to restore the system databases from SnapManager backup sets. For more information, see the following topics: |
Copyright © 1994-2006, Network Appliance, Inc. All rights
reserved.
Part No. 215-01752_A0
File: dr13.htm
Last updated: 01-Sep-2006 07:41:24