Dave Dave - 1 month ago 13
SQL Question

How to stop a single database in an sql instance?

For example i have 15 database in my instance how can i stop only one of them?. I only know is how to stop an instance... Thanks.

Answer

You can set it Offline in SSMS.

Right click -> Task -> Take Offline

You can set database to Restricted User Mode:

ALTER DATABASE database-name SET RESTRICTED_USER

but I'm not sure this works on SQL Server 2008

Comments