SQL Server Q&A

Symptoms
The Rebuild master utility (rebuildm.exe) provided with Microsoft SQL Server 2000 stops responding in the Server Configuration step if the source directory that contains data files is on a CD-ROM.
For example: <MyCDDriveLetter>:\x86\data
NOTE: You must terminate the action manually.
The following error message may occur:

Rebuild Master failed with error -1:
The error occurred during server configuration. Refer to install\cnfgsvr.out and the log\errorlog files in C:\Program Files\Microsoft SQL Server\MSSQL for diagnostic information.
Resolution
Rebuildm.exe needs the original master, pubs, msdb, and northwind files (both data and log). Rebuildm.exe copies these files into the installation directory of SQL Server 2000. When the copy completes, rebuildm.exe leaves all those files with the Read-only attribute set to on, which then prevents SQL Server from starting.

Symptoms
When you restore a database, recovery of logical file names of the database can fail, and the logical file names that correspond to the database in the master..sysaltfiles and the <Database_name>..sysfiles tables may differ.
Resolution
When you perform a backup and restore operation with a database that is in full recovery mode, this problem occurs if you modify the logical file names in the database after you back up the database but before you back up the transaction log.