SQLExpress 2005 fix master db

arthrex
arthrex used Ask the Experts™
on
Hi experts,

I have a problem with one of my sql server express installations. The service doesn't run and gives me the error:
An error occurred while processing the log for database 'master'.  If possible, restore from backup. If a backup is not available, it might be necessary to rebuild the log.

I found this site here, which explains how to fix the master db:
http://blogs.msdn.com/sqlserverstorageengine/archive/2006/09/26/772550.aspx

But I don't get the second part of the command
start /wait <CD or DVD Drive>\setup.exe /qn INSTANCENAME=SQLExpress REINSTALL=SQL_Engine REBUILDDATABASE=1 SAPWD=<NewStrongPassword> REINSTALLMODE=vomu

1.) Why do I have to use the cd or dvd drive when I extracted the files to my hard drive?
2.) My computer (XP) doesn't understand the command "start /wait"

Can someone help?

Thanks
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
you have to give full path of setup.exe from your hard drive. like:

START C:\abc\sqlExpress\setup.exe /qn and remaining stuff in command line
you must have START command. can you try following command in your DOS?

Start/?

If Start command is there in your OS, you will see it's help.

Author

Commented:
hmm...now the start command does work.

but now I get the message:
/qn is not valid
11/26 Forrester Webinar: Savings for Enterprise

How can your organization benefit from savings just by replacing your legacy backup solutions with Acronis' #CyberProtection? Join Forrester's Joe Branca and Ryan Davis from Acronis live as they explain how you can too.

can you try command without /qn?

Author

Commented:
Thanks,
I got it working.
Problem was that I was using quotation marks for the paths.
glad to know that your problem is resolved. cheers

Ritesh Shah

http://www.SQLHub.com

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial