8.If not correctly displayed in the SQL Server Installation Path window, enter the location of the existing SQL Server installation and click Continue.

The Rebuild Master Database window appears.

9.If it is not correctly displayed in the Rebuild Master Database window, enter the location and name of the existing MASTER device. Also enter a MASTER device size and click Continue.

The setup program will then rebuild the master database.

10.When rebuilding is complete and the completion window appears, click Exit.

NOTE: The files MASTER.DA@ and MASTER.AL@ are stored in the \MSSQL\INSTALL directory. When rebuilding the master database (or when installing SQL Server), one of these two files is used by the setup program. When the default sort order and character set are selected, MASTER.DA@ is expanded and copied onto the server, replacing MASTER.DAT. When an alternate character set and/or sort order is selected, MASTER.AL@ is expanded, copied onto the server, and several SQL scripts are run.

Restart Microsoft SQL Server in single-user mode

Before you can restore the master database, you must start Microsoft SQL Server in single-user mode.

1.Go to the SQL Server Manager and right-click the SQL server instance. Select Properties to open the SQL Server Properties window.

2.Under the General tab in the SQL Server Properties window, open the Startup Parameters window and type “–m” in the Parameter field.

3.Click the Add command, and then click OK. Close the SQL Server Properties window by clicking OK.

4.Restart the SQL server instance. (Right-click the SQL server instance and select Stop; right-click the SQL server instance and select Start.)

NOTE: You may find it convenient to start the SQL Server in single-user mode using the command line program, SQLSERVER.EXE, with option “/m”. This procedure will only work, however, if the SQL Server is configured to start using the current interactive user’s account.

Restore the master database from the most recent backup

1.Create a restore job and select the most recent backup version of the master database.

2.Run the restore job.

NOTE: This may take some time, typically 10 to 15 minutes, depending on the size of the master database. Restore only the master database while in single user mode. Do not restore any other databases.

Apply changes to the master database

1.Go to the SQL Server Enterprise Manger and right-click the SQL server instance. Select Properties to open the SQL Server Properties window.

2.Under the General tab in the SQL Server Properties window, open the Startup Parameters window and remove “–m” from the list of existing parameters.

3.Restart the SQL server instance. (Right-click the SQL server instance and select Stop; right-click the SQL server instance and select Start.)

If there have been no changes to the master database since the last dump, then proceed to Drop invalid databases and database devices (page 61).

60 Working with Third-Party Applications