Information about Replicaton Configuration

• chetanr.jain

  Hall of Fame

  Points: 3938

  More actions

  March 22, 2011 at 4:17 am

  #247301

  Hi,

  I will be looking after a new environment soon.

  In that, i need to check if any replication, Log Shipping, Mirroring & clustering is configured or not.

  I am planning to create a scripts which will give me first hand information about all the above technologies.

  I was able to create script for Log Shipping and Mirroring but stucked on Replication part.

  i want following information to be extracted :

  Publisher Name or IP

  Publisher database

  Distributor's Name or IP

  Distribution database

  Article or Articles

  Subscriber name or IP

  Subscriber database

  Replication Type ( Snapshot, Transactional, merge, Peer-to-peer)

  Shared Folder etc. any other important .

  Thanks in advance.

  Chetan

• Suresh B.

  SSC-Insane

  Points: 22986

  More actions

  March 22, 2011 at 5:41 am

  #1301807

  Some of the information, you can get from the following:

  select name, is_distributor, is_publisher, is_subscriber from sys.servers

  use distribution

  go

  select * from MSpublications

  select * from MSsubscriptions

  select * from MSarticles

  -- Shared folder

  sp_helpdistributor

• chetanr.jain

  Hall of Fame

  Points: 3938

  More actions

  March 22, 2011 at 6:32 am

  #1301832

  @suresh,

  Thanks for reply.

  i have framed following queries :

  select @@SERVERNAME as Server_Name,publisher_db,publication,

  publication_type, description from dbo.MSpublications

  select * from dbo.MSsubscriptions

  where subscriber_id > 0

  But still not comprehensive, i think