July 15, 2009 at 8:16 am
I am trying to rebuild a corrupt master database in SQL Server 2005. I have navigated to the folder where the setup.exe is in DOS, then made this the default folder, then run the following comand in DOS
start /wait setup.exe /qn INSTANCENAME=MSSQLSERVER REINSTALL=SQL_Engine REBUILDDATABASE=1 SAPWD = temppassword
The SQL Service is stopped.
The dos command runs for about a minute and then returns to the prompt. The Master database has not been rebuilt. Can you help ?
July 15, 2009 at 8:24 am
Did you follow the whole suggested process?
Here is a step-by-step guide... http://geekswithblogs.net/mskoolaid/archive/2005/12/17/63413.aspx
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.July 15, 2009 at 8:29 am
PaulB (7/15/2009)
Did you follow the whole suggested process?Here is a step-by-step guide... http://geekswithblogs.net/mskoolaid/archive/2005/12/17/63413.aspx
The SQL Server Service is stopped. It won't restart even in single user mode.
July 16, 2009 at 7:52 am
Have now managed it get it working in single user mode. But when I run step three nothing happens, it just pauses for a while and gos back to the prompt. Should I just run the Setup.exe through windows rather than DOS
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply