SQL SERVER – Change Database Access to Single User Mode Using SSMS

I have previously written about how using T-SQL Script we can convert the database access to single user mode before backup.

I was recently asked if the same can be done using SQL Server Management Studio.

Yes!

You can do it from database property (Write click on database and select database property) and follow image.

SQL SERVER - Change Database Access to Single User Mode Using SSMS singleuser1

Reference: Pinal Dave (https://blog.sqlauthority.com)

Solarwinds
Previous Post
SQLAuthority News – Book Review – Beginning T-SQL 2008 by Kathi Kellenberger
Next Post
SQLAuthority News – Statistics and Best Practices – Virtual Tech Days – Nov 22, 2010

Related Posts

5 Comments. Leave new

  • hi Pinal
    I can’t see the pic..
    would you please right down the structure too???
    tnx

    Reply
  • Sukanta Kumar Biti
    May 13, 2013 1:09 am

    if i have 30 database in single instance, do i need to go one by one and change in to single user mode to take the backup ?

    Also how do i take the back of complete 30 database in a single click ? Do we have any way through GUI mean SQL mangement Studio

    Reply

Leave a Reply

Menu