Thursday, December 18, 2008

Rebuild MSSQL 2005 Server's master database

With the installation CD in the CD drive (D:), execute the following command:

start /wait d:\setup.exe /qn INSTANCENAME=MSSQLSERVER REINSTALL=SQL_Engine REBUILDDATABASE=1 SAPWD=passwd

passwd should be the passwd for the sa user.