1. From a command prompt window change to the following directory:
"C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Release"
2. Next paste the following into the command prompt window and press “Enter”:
Setup.Exe /Action=RebuildDatabase /InstanceName=MSSQLSERVER /SqlSysAdminAccounts=Admin /Quiet
If you have SQL configured for Mixed Authentication Mode use the same syntax except you must also provide the /SAPWD parameter to specify the SA password. If you don't, you will get an error.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment