Post reply

Single user mode

  • September 29, 2009 at 5:34 am

    #211592

    HELP!

    How can i enable my instance to operate in single user mode (I want to backup and restore a system database).

  • September 29, 2009 at 6:03 am

    #1059408

    use this command to start sql server from command prompt:

    for default instance:

    sqlservr.exe -m

    for named instance:

    sqlservr.exe -m -s <instancename>

    HTH

    ---------------------------------------------------
    "Thare are only 10 types of people in the world:
    Those who understand binary, and those who don't."

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply