I need the best way for the scenario because of which I got irritated. I do have 3 Production database Servers Srv1, Srv2 and Srv3. I configure transactional replication among these servers. Srv1 is Publisher and Srv2 and Srv3 are subscribers.
On production server everything running fine without any problem.
I have QA environment same as production replication configured. On request of QA team, I need to refresh QA with production databases weekly (almost), which cause to fail replication in QA environment.
Because I have 1000 tables dropping and re-creating publications takes too much time on Srv1.
If I refresh database without dropping publication and recreate publication using backup script I get
The process could not execute ‘sp_repldone/sp_replcounters’