Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
DB Engine
SQL ServerMSDESQL Server CE
Services
Analysis (Data Mining)Analysis (OLAP)DTSIntegration ServicesNotification ServicesReporting Services
Programming
CLRConnectivitySQLXML
Other Technologies
ClusteringEnglish QueryFull-Text SearchReplicationService Broker
General
Data WarehousingPerformanceSecuritySetupSQL Server ToolsOther SQL Server Topics
DirectoryUser Groups
Related Topics
MS AccessOther DB ProductsMS Server Products.NET DevelopmentVB DevelopmentJava DevelopmentMore Topics ...

SQL Server Forum / Other Technologies / Replication / August 2008

Tip: Looking for answers? Try searching our database.

Replication Checker

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
CLM - 20 Aug 2008 18:45 GMT
I'm using transaciton immediate replication on SS 2000 SP4.  The problem is
that replication will sometimes have problems, i.e. I'll go into Ent Mgr and
see the publisher is red and needs to resync'd.  The standard alerts that it
is re-trying don't really work - I'd like to get an alert that tells me when
it goes to red in Eng Mgr, i.e. when it  needs to be resync'd.  How can I do
that?  Is there a way to script that?  Is there a third party tool that will
do that?
Paul Ibison - 23 Aug 2008 18:09 GMT
Not too sure why the alert doesn't work for you in SQL Server 2000, but I
enable email messages on the actual jobs themselves rather than the alerts.
You could add such a response on the distribution agent. Alternatively use
something like SQL Sentry to monitor all your jobs centrally.
HTH,
Paul Ibison (www.replicationanswers.com)
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2010 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.