Replication Issue

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 High Availability » Replication Issue

Replication Issue

Rate Topic

Display Mode

Topic Options

Author

Message

mahesh.dasoni

Posted Friday, November 23, 2012 6:52 AM

SSC Journeyman

Group: General Forum Members
Last Login: Yesterday @ 7:41 AM
Points: 81, Visits: 859

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

Alan.B

Posted Tuesday, November 27, 2012 10:00 PM

SSC Veteran

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 9:06 AM
Points: 223, Visits: 1,137

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.

-- AJB
xmlsqlninja.com

Post #1389504

« Prev Topic | Next Topic »

Permissions