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.


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

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

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

  • 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


Leave a Reply Cancel reply

Exit mobile version