Master database rebuild not working using Setup.exe

Hi there,

We want to rebuild the system databases on a SQL Server 2005 instance. After starting the service in single-user mode, we open a command window on C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap and then we try this command:

.\Setup /QUIET /ACTION=REBUILDDATABASE /INSTANCENAME=MSSQLSERVER /SQLSYSADMINACCOUNTS=***** /SAPWD=*****

After a couple of seconds, a window from MS SQL Server 2005 Setup pops up on the screen, it says: SQL Server Setup is scanning your computer's configuration. Then this window it's closed by itself and another window pops up. It's from Windows Installer and it says:

Windows Installer v4.xxxxx

msiexec /option <required parameter> [optional parameter]

...more help... etc.

And that's it. The system databases are not rebuilt.

We can't figure out what's wrong. Please, any pointers or insight is much appreciated.

Thanks in advance,

-Ed

August 27th, 2015 7:04pm

To rebuild the system databases you no need to be in single user mode.

Go to boot folder and use the command rebuild command.

If you wanted to restore master database from previous backup then you need to change to single use mode and restore master.

I hope this info helps you.

Free Windows Admin Tool Kit Click here and download it now
August 27th, 2015 8:15pm

To rebuild the system databases you need to run the setup command from the Command prompt and follow the following procedure: 

1. Click Start, click Run, type cmd, and then click OK. 
2. Run the following command to rebuild the system databases:

start /wait <CD or DVD Drive>\setup.exe /qn INSTANCENAME=Instance_Name REINSTALL=SQL_Engine REBUILDDATABASE=1 SAPWD=StrongPassword

For example:

start /wait D:\setup.exe /qn INSTANCENAME=MSSQLSERVER REINSTALL=SQL_Engine REBUILDDATABASE=1 SAPWD=p@ssw0rd


 procedure is often used to rebuild the master database for a corrupted installation of SQL Server.


References:

http://msdn2.microsoft.com/en-us/library/ms144259.aspx

August 28th, 2015 1:08am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics