Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

Kill Active connections Expand / Collapse
Author
Message
Posted Thursday, October 22, 2009 9:21 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Today @ 5:52 PM
Points: 3,116, Visits: 11,387
anand.ramanan (10/21/2009)
After setting a db to offline it wont be available for a restore...


That is not true. You can restore over a database when it is offline.

Post #807245
Posted Wednesday, December 23, 2009 2:34 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Monday, June 23, 2014 6:03 AM
Points: 920, Visits: 702
There is another option that you can use to kill all active connection the database and make database read only


ALTER DATABASE <mydb> SET READ_ONLY WITH ROLLBACK IMMEDIATE


Abhijit - http://abhijitmore.wordpress.com
Post #838418
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse