Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase ««12

Error checking in SQL Jobs Expand / Collapse
Posted Wednesday, September 18, 2013 7:51 AM



Group: General Forum Members
Last Login: Yesterday @ 1:53 PM
Points: 1,711, Visits: 10,485
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.)

Post #1495929
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse