+ Reply to Thread
Results 1 to 2 of 2

Sql 2005 single user mode: change back to multi user ?

  1. Sql 2005 single user mode: change back to multi user ?

    Hi All,I was trying to take a quick backup of a db and wanted to restrict
    access for
    a short time and set it to single user access. Now I am wantting to change
    it back but the gui is not allowing my to do so. What is quickest way to
    change it back?ThanksSandy



  2. Re: Sql 2005 single user mode: change back to multi user ?

    Sandeep Singh wrote:

    > Hi All,I was trying to take a quick backup of a db and wanted to
    > restrict access for a short time and set it to single user access.
    > Now I am wantting to change it back but the gui is not allowing my to
    > do so. What is quickest way to change it back?ThanksSandy


    You can set a database to multi-user using the following statement:

    ALTER DATABASE db SET MULTI_USER

    However, that won't work if the database is in single-user mode and a
    user is currently connected to it. You need to disconnect that user
    first (maybe it's even you, so close Management Studio and open it
    again before retrying).

    --
    Razvan Socol
    SQL Server MVP

+ Reply to Thread