Jobs in Database Mirroring - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

High Availability (2005)

Jobs in Database Mirroring

Author

Topic

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-01-03 : 10:30:48

How do i make sure Jobs are disabled in the mirrored Server and it automatically Enables as soon as Failover happens in Database Mirroring?

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-01-03 : 13:40:30

Not sure how you would know when the switchover happens, but you can use this to do the work:
http://weblogs.sqlteam.com/tarad/archive/2003/10/17/325.aspx

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

sqlsquirrel
Starting Member

21 Posts

Posted - 2008-01-15 : 14:30:03

I would use Tara's procedure to enable the jobs on your mirrored server. If you use a witness server in your database mirroring configuration and set it to automatically "switch over" as opposed to a "manual switch over" you can setup the witness to execute this procedure after the "switch-over" happens.

Brett Davis
Senior SQL Server DBA
For more helpful tips checkout my blog at: http://www.lockergnome.com/sqlsquirrel/

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources