Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Time required to take a 2005 DB off-line

Posted on 2009-12-30
1
Medium Priority
?
174 Views
Last Modified: 2012-05-08
Why does it take a long time to take a MS SQL-2005 DB off-Line?
Any reference to the Microsoft posting/document would be helpful
0
Comment
Question by:LFreehauf
1 Comment
 
LVL 60

Accepted Solution

by:
chapmandew earned 2000 total points
ID: 26151730
Connections to the db are being closed. If you put the db in single user mode first and then take it offline, the offline step will be faster.
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Question has a verified solution.

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

by Mark Wills Attending one of Rob Farley's seminars the other day, I heard the phrase "The Accidental DBA" and fell in love with it. It got me thinking about the plight of the newcomer to SQL Server...  So if you are the accidental DBA, or, simp…
Introduction: When running hybrid database environments, you often need to query some data from a remote db of any type, while being connected to your MS SQL Server database. Problems start when you try to combine that with some "user input" pass…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
How can you see what you are working on when you want to see it while you to save a copy? Add a "Save As" icon to the Quick Access Toolbar, or QAT. That way, when you save a copy of a query, form, report, or other object you are modifying, you…

569 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