SQL Server Performance

Status of Replication through ASP.NET

Discussion in 'SQL Server 2005 Replication' started by Aleyali, Feb 23, 2006.

  1. Aleyali New Member

    I need to know the current status of replication through ASP.NET component or class, i.e. to check wether the replication is running or has stopped due to some error, the service may stop due to non availability of connection between the two servers, this may happen because of network break down or internet service interruption.

    The two servers are placed at different geographical locations. Usually this connection breaks and the replication fails. I need a ASP.NET component or class to track this.

    Both of the servers have win 2000 and Sql server standard addition.

    Please help me.
  2. satya Moderator

    The status of replication will be logged to SQLAgent log and Snapshot agent, you may try from ASP.NET to capture this information from these text files.

    HTH

    Satya SKJ
    Microsoft SQL Server MVP
    Contributing Editor & Forums Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.

Share This Page