Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Replication Issue Expand / Collapse
Author
Message
Posted Friday, November 23, 2012 6:52 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Saturday, July 12, 2014 12:11 AM
Points: 81, Visits: 912
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
Post #1388167
Posted Tuesday, November 27, 2012 10:00 PM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Monday, July 28, 2014 4:49 AM
Points: 556, Visits: 2,581

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.


-- Alan Burstein



Read this article for best practices on asking questions.
Need to split a string? Try this (Jeff Moden)
Need a pattern-based string spitter? Try this (Dwain Camps)
My blog
Post #1389504
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse