• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 151
  • Last Modified:

stop a database from serving requests... but not the instance

I want to take a database offline.  there are mulitiple databases on this sql instance.  I don't want to detach the database and i don't want the other databases in the sql instance to be affected at all.

the database that needs to go offline needs to not allow users to connect at all
i have sql 2008 and another server running sql 2012.
how can i accomplish this?

Thank you
0
jamesmetcalf74
Asked:
jamesmetcalf74
2 Solutions
 
Phillip BurtonDirector, Practice Manager and Computing ConsultantCommented:
Disable the users, or Change maximum number of connections to 0.

Or, simplest, back it up with NoRecovery.
0
 
Mohammed KhawajaManager - Infrastructure:  Information TechnologyCommented:
Or right click on the database and select the option to take database offline
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now