September 15, 2011 at 9:26 am
Hi All,
I am trying to restore the master database in sqlserver7.0
following the below steps.
1)
net stop msssqlserver
2)sqlservr -m
execution of sqlservr -m taking much time to get executed .
Can any one please let me know if there is any other process to put sqlserver in single user mode
or
How to come out of this error?
Regards,
Harish.Gannnavarapu
September 15, 2011 at 9:52 am
That is the only way to put SQL Server in single user mode. Have you checked the error log to see what might be happening?
September 15, 2011 at 10:34 am
You mentioned an error, can you be more specific on the error?
Chris Powell
George: You're kidding.
Elroy: Nope.
George: Then lie to me and say you're kidding.
September 15, 2011 at 11:13 am
Hey i didn't say that i am getting error
it's taking long time to execute
intially i got out put like
closing master ......mdf and ldf files
and other databases
later it showed that stopping xp_sendmail isstopped again started.
after that it's not displaying any thing
How long will it take to execute the query?
Regards,
Harish.G
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply