This article describes the steps that you must perform to
rebuild a master
database on a Virtual (Clustered) SQL Server instance.
How to Rebuild the Master Database on a Virtual (Clustered) SQL Server 2000 Server
To rebuild the master
SQL Server 2000 database, perform the following steps:
- Make sure that the SQL Server resources are being
controlled by the node in which you execute Rebuildm.exe.
- Bring the SQL Server virtual server offline by using the
SQL Server Service Manager.
- Make sure that the original shared installation files or
the SQL Server installation CD is available.
If you use the SQL
Server installation CD, copy all the files from the CD to a local hard drive.
Remove the read-only attribute from the files after you copy them to the hard
drive. For more information, refer to the following article in the Microsoft
BUG: Rebuildm.exe Utility Stops Responding When Source Directory is on a CD
- Execute Rebuildm.exe and point it to:
- The original shared installation files.
- The files that you copied from the CD to the local hard
- Select Windows Collation, or SQL Collation.
- After the Rebuildm.exe program completes, verify that you
can bring the resources online and that they successfully fail over.
- Execute the sp_helpsort stored procedure to verify the collation.
: The preceding steps do not include the steps that are necessary
to rebuild user databases. If you have a recent backup of the master
database, you may restore it at this point. If not, you must
restore or attach the user databases.
You must start SQL Server from
a command prompt on the active node to connect and restore. Note
In SQL Server 2005, the Rebuildm.exe file has been discontinued. To rebuild the master
database, use the Setup.exe file.
SQL Server 2000 Books Online; topic: "Rebuilding Master
Article ID: 298568 - Last Review: December 10, 2005 - Revision: 4.2
- Microsoft SQL Server 2000 Enterprise Edition
- Microsoft SQL Server 2000 Developer Edition
- Microsoft SQL Server 2005 Standard Edition
- Microsoft SQL Server 2005 Developer Edition
- Microsoft SQL Server 2005 Enterprise Edition