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?
adimitAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

mdagisCommented:
How can it run if it is offline? I don't get it.
0
adimitAuthor Commented:
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.
0
mdagisCommented:
What exactly triggers the synchronization? Maybe you could catch it from there and just do not start it from the begging if the subscriber is offline.
0
adimitAuthor Commented:
The synchronization is transaction based. It is generated from the distributor. There is no way of controlling the synchronization. It occurs naturally if data is sent to the distributors.

Anoter option is to set a switch to ignore errors.

At  the very least I'd like to notify users that a connection is down. How can i detect that a connection is down using SQL?
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.