MSSQL 2005 Error: Cannot recover the master database

Published: Mar 15th, 2012 Category: Microsoft Windows, MSSQL

Sometime due to some technical problems or uncleaned shutdown master database of MSSQL gets corrupted and while starting MSSQL service it throws following Error

Application Log in Event Viewer shows following Error

Cannot recover the master database. SQL Server is unable to run. Restore master from a full backup, repair it, or rebuild it.

The above error shows that the System Database like Master has been corrupted. To fix this issue we need to rebuild the MSSQL system databases from Installation Disk.

1) Insert MSSQL Installation Disk in Optical Disk Drive

2) Go to Command Prompt (Start >> run >> cmd >> Enter)

3) Execute Following Command:

start /wait []setup.exe /qn INSTANCENAME=[Instance Name] REINSTALL=SQL_Engine REBUILDDATABASE=1 SAPWD=[Password]

Here, [Instance Name] will be the name of the MSSQL instance you want to set like MSSQLSERVER and [Password] will be the sa password for MSSQL.

Now try to start MSSQL service.

• Share this:

Related posts:

1. Guide to MS SQL 2008 Transactional Replication (Configure Distributor) Part-II

Tags: MSSQL 2005 Error, rebuild master database, recover master database, repair system database

3 Responses to “MSSQL 2005 Error: Cannot recover the master database”

1. 
   Tweets that mention MSSQL 2005 Error: Cannot recover the master database | -- Topsy.com
   on Apr 21st, 2010
   @ 11:07 pm: 

   [...] This post was mentioned on Twitter by eITWebguru. eITWebguru said: eIT MSSQL 2005 Error: Cannot recover the master database: Sometime due to some technical problems or uncleaned shu… http://bit.ly/9DWVRI [...]

2. 
   MSSQL 2005 Error: Cannot recover the master database « .:][ Gr8 Admin Team ][:.
   on Apr 26th, 2010
   @ 11:26 am: 

   [...] Read more here Categories: MSSQL, Windows Tags: MSSQL 2005 Error, rebuild master database, recover master database, repair system database Comments (0) Trackbacks (0) Leave a comment Trackback [...]

3. 
   MSSQL 2005 Error: Cannot recover the master database | eITWebGuru
   on May 6th, 2010
   @ 9:56 am: 

   [...] Read more here [...]