April 18, 2011 at 10:12 am
SQL Gurus,
I am trying to rebuild the master database after the HD partition holding the db files crashed. I ran the following from the command prompt :
C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Release>setup/ACTION=REBUILDDATABASE/QUITE/INSTANCENAME=MSSQLSERVER/SQLSYSADMINACCOUNTS=domain\myaccount/SAPWD=sapwd/SQLCOLLATION=SQL_Latin1_General_CP1_CI_AS
but when I run it it give me an error saying the The specified value for WORKLOW is wrong.
Can somebody please help me ? Did I select the incorrect syntax?
Thank you in advance for your help
April 19, 2011 at 6:55 am
You misspelled QUIET you have QUITE. Try this
setup /ACTION=REBUILDDATABASE /QUIET /INSTANCENAME=MSSQLSERVER /SQLSYSADMINACCOUNTS=domain\myaccount /SAPWD=sapwd /SQLCOLLATION=SQL_Latin1_General_CP1_CI_AS
Also, unless you are in MIXED MODE AUTHENTICATION you do not need to supply the sapwd.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
April 19, 2011 at 10:04 am
http://www.sqlcoffee.com/Troubleshooting007.htm
Regards,
Syed Jahanzaib Bin Hassan
MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA
My Blog
Regards,
Syed Jahanzaib Bin Hassan
BSCS | MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA
My Blog
www.aureus-salah.com
April 21, 2011 at 3:27 pm
thx guys . Yes I made a typeo when issuing the command QUIET and also i did not leave the space between the strings
instead of typing setup /ACTION=REBUILDDATABASE /QUIET
I typed in setup/ACTION=REBUILDDATABASE/QUITE.....
After making the changes it is working fine now.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply