none
Transactional replication publication created date RRS feed

  • Question

  • Hi Friends,

    We have transactional replication configured in our environment. We remove replication and install it again during db refresh activity . Do we have system table which tracks the date when publications are created. I don't find that info in mspublications.

    Thanks

    Udhayan

    Friday, March 25, 2016 10:41 AM

Answers

All replies

  • No, there is nothing that will do this.

    When you drop a publication it will cleanup after itself and delete the meta data references you are looking for.


    looking for a book on SQL Server 2008 Administration? http://www.amazon.com/Microsoft-Server-2008-Management-Administration/dp/067233044X looking for a book on SQL Server 2008 Full-Text Search? http://www.amazon.com/Pro-Full-Text-Search-Server-2008/dp/1430215941

    Friday, March 25, 2016 6:18 PM
    Moderator
  • When you create publications, it creates distribution agents too. Can you please look at the below system table in distribution db. Check the creation_date. This should similar to the creation date of the publication. 

    select * from MSdistribution_agents

    Hope this helps. 

    Friday, March 25, 2016 9:55 PM
  • As Hilary pointed out, we dont have a table which directly says your publication is created on this date.

    Like Susantha told, msdistribution_agents has a creation_date column through we can infer when your distribution agent is created. In my case i ran the script to drop all publication, so i can see respective distribution agents created on that date. But what if someone just drops the distribution agent and creates it again, we will have a recent date but that this not the date my publication was created.

    Thanks

    Tuesday, March 29, 2016 2:45 PM