master restore in sqlserver 7.0

  • 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

  • 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?

  • 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.

  • 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