Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
tocroi72
Yak Posting Veteran
89 Posts |
 Posted - 2005-09-13 : 17:21:44
|
| Hello all,I am trying to practice restoring Master database in SQL server. I follow the instructions i got from the web. The first step is make a complete full backup of all database including Master. Then shut down SQL server, run a DOS command to start SQL server in a single mode. ( this is the DOS command: sqlservr.exe -c -m )Now i can not start SQL server anymore? can someone please tell me what is the problem here? and is there a DOS command to start my SQL server to the previous state? (not in a single user mode).Thanks very much for your help. |
|
|
madness
Starting Member
13 Posts |
Posted - 2005-09-13 : 17:33:41
|
| Check that you actually stopped the instance that you got running in single user mode first. Ie kill the SQLServer.exe process if it exists. Then you should be able to start the SQL Service normally as you did before. Otherwise please post the an exert of the sql log file here for more details. |
 |
|
|
|
|
|
Need help - SQL server start in single mode