Tuesday, May 3, 2011

recover MS SQL 2005 master database with original media

Here are the instructions on how to rebuild master database. This would be useful during DR.

SQL SERVER 2005 install media should be restored to the same location from where sql server was installed originally.


The location can be found from SQLSetup001__SQL.log ? Search for Product in this log file. This point to the location from where the sql server 2005 w

Go the sql server configuration and change the properties to startup manual and stop the sql server services

start /wait setup.exe /qn INSTANCENAME= REINSTALL=SQL_Engine REBUILDDATABASE=1 SAPWD=

Default instance name is MSSQLSERVER