You are currently offline, waiting for your internet to reconnect

How to rebuild the master database on a virtual SQL Server instance

Extended support for SQL Server 2005 ended on April 12, 2016

If you are still running SQL Server 2005, you will no longer receive security updates and technical support. We recommend upgrading to SQL Server 2014 and Azure SQL Database to achieve breakthrough performance, maintain security and compliance, and optimize your data platform infrastructure. Learn more about the options for upgrading from SQL Server 2005 to a supported version here.

This article was previously published under Q298568
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:
  1. Make sure that the SQL Server resources are being controlled by the node in which you execute Rebuildm.exe.
  2. Bring the SQL Server virtual server offline by using the SQL Server Service Manager.
  3. 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 Knowledge Base:
    273572 BUG: Rebuildm.exe Utility Stops Responding When Source Directory is on a CD
  4. Execute Rebuildm.exe and point it to:
    • The original shared installation files.

    • The files that you copied from the CD to the local hard drive.
  5. Select Windows Collation, or SQL Collation.
  6. After the Rebuildm.exe program completes, verify that you can bring the resources online and that they successfully fail over.
  7. Execute the sp_helpsort stored procedure to verify the collation.
NOTE: 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 Database"
cluster rebuildm

Article ID: 298568 - Last Review: 12/10/2005 00:21:14 - 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

  • kbinfo KB298568