Search This Blog

Saturday, August 18, 2007

Rebuild Database fails

Error Message Description
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.

Cause
Master Database is rebuild from a CD and the .mdf and .ldf files are read-only in the CD and hence the same gets copied over,hence the SQL Server is unable to start.

Resolution
Copy the files from CD to a share location and remove the read-only option for database files and then rebuild the master

No comments: