Solved

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

Posted on 2014-11-07
2
143 Views
Last Modified: 2014-11-07
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
Comment
Question by:jamesmetcalf74
2 Comments
 
LVL 24

Assisted Solution

by:Phillip Burton
Phillip Burton earned 250 total points
ID: 40429293
Disable the users, or Change maximum number of connections to 0.

Or, simplest, back it up with NoRecovery.
0
 
LVL 25

Accepted Solution

by:
Mohammed Khawaja earned 250 total points
ID: 40429445
Or right click on the database and select the option to take database offline
0

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

789 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question