adimit
asked on
SQL Server Watchdog timer and replication (transaction)
I'd like to stop replication from running to any subscriber that is offline. This involves detecting that SQL Server is not running on the remote machine. I'd like the script to run on the distributor.
Is this possible?
Is this possible?
How can it run if it is offline? I don't get it.
ASKER
The publisher tries to replicate to a node that is off-line producing an error which in-turn might hold up replication to other servers.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.