How to rebuild the master database (Rebuild Master utility)

To rebuild the master database

  1. Shutdown SQL Server; then run Rebuildm.exe in the \Mssql7\Binn directory.
  2. Click Browse.
  3. Select the \Data folder on the Microsoft® SQL Server™ compact disc or in the shared network directory from which SQL Server was installed; then click OK.
  4. Click Settings. Verify or change the character set, sort order, and Unicode collation used for the master database and all other databases.

    The default character set, sort order, and Unicode collation are shown initially, which may not be the values selected during SQL Server Setup. You can select the same combination used earlier or select a new combination; then click OK.

  5. Click Rebuild.

    The Rebuild Master utility reinstalls the master database.

  


(c) 1988-98 Microsoft Corporation. All Rights Reserved.