November 6, 2001 at 7:04 pm
Hi all
If I have an Active/Active cluster, from what server dones the SQL*Agent run? to they talk to one another? just wondering how SQLServer manages the running of jobs in such an environment and if manual re-starts etc are required if you only run it on 1 node and it fails.
Cheers
Chris
Chris Kempster
www.chriskempster.com
Author of "SQL Server Backup, Recovery & Troubleshooting"
Author of "SQL Server 2k for the Oracle DBA"
November 7, 2001 at 9:03 am
in an A/A setup you are running two copies of sql. they are basicly seprate and do not talk to each other. If one node fails the other node gets both instances of SQL on it.
November 7, 2001 at 11:22 am
So I assume that msdb is included and SQL Agent is picked up by the second server?
Is this correct? Brian? Anyone tested it?
Steve Jones
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply