SQL Server Performance Forum – Threads Archive

Detection for replication and log shipping

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.

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.

]]>