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.

Reference: Pinal Dave (http://blog.SQLAuthority.com)

About these ads

5 thoughts on “SQL SERVER – Change Database Access to Single User Mode Using SSMS

  1. Pingback: SQL SERVER – Weekly Series – Memory Lane – #004 « SQL Server Journey with SQL Authority

  2. Pingback: SQL SERVER – Weekly Series – Memory Lane – #005 « SQL Server Journey with SQL Authority

  3. Pingback: SQL SERVER – Weekly Series – Memory Lane – #006 « SQL Server Journey with SQL Authority

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

    Like

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s