SQL Server Performance

Detection for replication and log shipping

Discussion in 'SQL Server Log Shipping' started by Ravih, Aug 10, 2004.

  1. Ravih New Member

    How can we identify whether replication or Log shipping is ON on SQL server 2000?

    How do we detect where SQL server is Publisher, Distributor or Subscriber in Sql server replication?


    Thanks in advance.
  2. satya Moderator

    SELECT DATABASEPROPERTYEX('Northwind', 'IsPublished')
    -- for publisher information 'IsSubscribed' for subscriber information.

    I'm not really sure about findout whether Log shipping is enabled on the databsae or not with a statement. Only the way is to findout from jobs or from Log shipping monitor on that server.

    HTH

    (I wonder how I missed this question which was posted a month ago)

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

Share This Page