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
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy