CODEWITHSUNDEEP
sqlsql-server-2008
Dave
Dave

Reputation: 85

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.

Upvotes: 4

Views: 17014

Answers (2)

McNets
McNets

Reputation: 10807

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

Upvotes: 5

FLICKER
FLICKER

Reputation: 6683

Stopping a database means making it unavailable for users. You should make database off-line. Right click on database and select Off-Line.

Upvotes: 1

Related Questions