Post reply

Replication Issue

  • November 23, 2012 at 6:52 am

    #271145

    I have a Database on which we have Logshipping and Transaction replication both configured.

    Once i do DR Drill and test my application on DR,then after testing when i switch back to my Production then Replication starts failing.

    Is there any step by which i can prevent from Replication from failing.

    I have read article which states it can be done.

    http://blogs.msdn.com/b/repltalk/archive/2010/02/19/the-process-could-not-execute-sp-repldone-sp-replcounters.aspx

    Just wanted to know whether it is correct because i will doing it on the production and have to be very sure before doing and don't have any test enviornment

  • November 27, 2012 at 10:00 pm

    #1562923

    Just wanted to know whether it is correct because i will doing it on the production and have to be very sure before doing and don't have any test enviornment.

    Production is not the best place to do stuff for the first time. Setting up a VM with SQL on your laptop then testing this out first will likely consume less time consuming than troubleshooting replication and log shopping issues in prod.

    I have never done what you are doing (log shipping and transactional replication on the same 2008 db) but I HAVE paid the price for doing stuff in prod without testing it first.

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply