How to stop a single database in an sql instance?

Question

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 1

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