When you go into the command line and start sql server with the -m ( or
any or even no params), the log messages are returned to you at the
command line.... When the messages stop, the server is up and
running... and you are cool to begin your restore... It is not hung
up... it is actually waiting for work to do... When you close the
command line window, SQL will shut down...
> I would like to restore the master database. Is the only way to put
> single mode is to do "sqlservr.exe -m" at the dos prompt? It seemed
> taking a long time to start the server when it only takes seconds to
> in the GUI. Any ideas on this? (It stopped giving any output and the
> prompt just blinked for awhile but was not completed doing whatever
Wayne Snyder MCSE, MCDBA, MCT, SQL SERVER MVP
IKON Education Services, C*te, NC
(Please respond to the newsgroups.)
Sent via Deja.com http://www.veryComputer.com/
Before you buy.