SQL 2008 mirroring – are jobs active on mirror on just on failover?
When mirroring SQL 2008 Databases when the principal is active do the jobs run on the mirror or just on failover?
Software/Hardware used:
SQL 2008
Software/Hardware used:
SQL 2008
ASKED:
September 4, 2009 9:03 PM
UPDATED:
September 4, 2009 10:24 PM
Answer Wiki:
The jobs should only be run against the active database. The mirror copy cannot be read or written to, so you'll want to have the jobs on that server disabled until you have failed over the server. That or deal with the fact that all the jobs on that server will fail until that server is the active server.
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
