Rebuilding the Master Database

SQL Server 2000

Rebuilding the master database is done using the Rebuild Master utility "rebuildm.exe" which is located in the 80\Tools\Binn directory of the SQL Server installation.

Select the server and instance that you want to rebuild. Now you are going to need access to the files from the install CD for SQL Server. Browse to the Data dircetory in the SQL Server install files. Set the collation you want SQL Server to be using, and hit Rebuild.

If you are run the utility using the CD as the source, you might encounter the error:

Rebuild Master failed with error -1:

Microsoft Support Q273572 lists the error as a bug in the utility. As it copies the read-only files from the install CD it does not turn off the read-only flag. To work around this simply copy the Data directory from the CD to the harddrive and turn off the read-only setting for the files. Then go ahead and rebuild again.

With the master database rebuilt, verify that it worked by starting SQL Server. The instance should start, but all the previous settings and databases will be missing. Restoring the Master database will bring back all the previous instance settings.

Read on about how to Restoring the Master Database.



Share
  • Facebook
  • Google Bookmarks
  • Ask
  • LinkedIn
  • Socialogs
  • Wikio
  • Digg
  • Twitter
  • SlashDot
  • Reddit
  • MySpace
  • Del.icio.us
  • Blogter
  • BlogMemes
  • Yahoo Buzz






Rebuilding the Master Database | 0 comments | Create New Account
The following comments are owned by whomever posted them. This site is not responsible for what they say.


Gold Coast Aquarium Maintenance | Gold Coast Marine Fish | Gold Coast Tropical Fish
Jewel Jones - Counselling Service - Penrith, Richmond
 
     
 Copyright © 2017 Julian Kuiters
 All trademarks and copyrights on this page are owned by their respective owners.