can not start sql server in single user mode

[gc]

I try to use command sqlservr.exe -m to start sql server 7.0 (Standard version)in single user mode. The problem is after run the command in DOS for a while the process can not be complete. What's wrong ? Please help and Thanks in advance!

George Chen

 

[tlbroadbent]

Are you sure SQL Server has not started? The DOS prompt may show no activity because nothing is happening on SQL Server at the moment. That does not mean SQL is not running. You'll need to open a GUI tool to proceed with the restore.

Have you tried to open Query Analyzer and connect to the server? Terry Broadbent
Please review faq183-874.

"The greatest obstacle to discovery is not ignorance -- it is the illusion of knowledge." - Daniel J Boorstin

 

[gc]

Hi! Terry:
Thank you for reply.
May be I din't explain my problem clearly. That is my procedure to set sql server in single user mode:
First I stop SQL server, then run the command sqlservr.exe -m. Because the sqlservr.exe did not end so I quit the process in DOS. then start sql server again and using Query Analyzer to check the database property Issingleuser. The result is O. My question is why the command did not complete in DOS.
Thank you again!
George

 

[tlbroadbent]

The point of my post was that the command prompt window will not close when you start SQL Server from the command prompt. You just need to keep it running while you log in with Query Analyzer and complete your work. Then you can termninate SQL Server running in the command window. Terry Broadbent
Please review faq183-874.

"The greatest obstacle to discovery is not ignorance -- it is the illusion of knowledge." - Daniel J Boorstin