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

Error checking in SQL Jobs Expand / Collapse
Author
Message
Posted Wednesday, September 18, 2013 7:51 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: Today @ 12:33 PM
Points: 978, Visits: 5,086
Another option for preventing connections to the DB so you can restore in peace, would be to set it to offline, rather than single_user or restricted_user.

See this topic:
"What can I do to an offline DB?"

I've been using this method to refresh QA DBs here at work and it's been working like a champ. Still need to go in and check for orphaned users, but that only takes a couple minutes (and likely could even be scripted out.)

Jason
Post #1495929
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse