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)
Is your SQL Server running slow and you want to speed it up without sharing server credentials? In my Comprehensive Database Performance Health Check, we can work together remotely and resolve your biggest performance troublemakers in less than 4 hours.
Once you learn my business secrets, you will fix the majority of problems in the future.
Have you ever opened any PowerPoint deck when you face SQL Server Performance Tuning emergencies? SQL Server Performance Tuning Practical Workshop is my MOST popular training with no PowerPoint presentations and 100% practical demonstrations.
Essentially I share my business secrets to optimize SQL Server performance.
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