What would be the most practical way to shut down a database to access for any user?
I need to practically shut down a specific database on a SQL Server for test purposes, and would like to know the most practical common solution.
Thanx
sql server
What would be the most practical way to shut down a database to access for any user?
I need to practically shut down a specific database on a SQL Server for test purposes, and would like to know the most practical common solution.
Thanx
Best Answer
You can take if offline or open as a single user.
To take it offline adapt the followin script, original at sqlauthority
To make it available to a single user account original at sqlauthority: