Post reply

Rebuilding master database using command prompt

  • February 12, 2007 at 9:52 am

    #115520

    Hi,

    I am trying to run the following command to rebuild the master database but nothing happens and I get a prompt - 'more?'

    What am I missing?

    start /wait path to setup.exe on the local drive(copied over from the dvd/qn INSTANCENAME=MSSQLSERVER REINSTALL=SQL_Engine REBUILDDATABASE=1 SAPWD= password

    Thanks

    KR

  • February 12, 2007 at 4:03 pm

    #689316

    Did you put a path in double quotes " if the path contains spaces?

    We used the syntax from BOL:

    start /wait setup.exe /qn INSTANCENAME=<InstanceName> REINSTALL=SQL_Engine REBUILDDATABASE=1 SAPWD=<NewStrongPassword>

    and I think we switched to the setup directory in command prompt first.

    Regards,Yelena Varsha

  • February 12, 2007 at 4:07 pm

    #689317

    No, that was not it,  I found the problem -  our password had some special characters that did not work well in command prompt.  Once I removed those( &, +) everything went smoothly after that.

     

    Thanks

    KR

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply