by webmaster
24. January 2010 20:39
PROBLEM:
My company is heavily dependant on SQL Server transactional replication and once in a while the default alerts are not sufficient and sometimes we want to be able to disable alerts when we perform mainteance. In this tip I will show you a few scripts I have implemented to allow me to better manage our transactional replication.
SOLUTION:
I wrote a few customized jobs that cover the following:
- Putting relipcation alerts in maintenance mode
- Check replication distributor agents for continuous replication
- Check replication logreader agents
Read more
Tip provided by Kun Lee
