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 (https://blog.sqlauthority.com)
5 Comments. Leave new
hi Pinal
I can’t see the pic..
would you please right down the structure too???
tnx
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