sql server replication scripting | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

sql server replication scripting

Hey everyone, I have a nasty replication scenario in my test and QA environment that I am trying to deal with. I have a database replication scenario that goes like this. production_db get replicated (transactional) through a dedicated distributor to a reporting_db. I have to cleanly push a backup of the production database to the QA environment for app validation and still keep the replication scenario intact. I am looking for the cleanest way to ensure this works. Here are my ideas. IDEA 1
script the pubs and subs ( create and del )
drop pubs and subs on both servers from scripts
restore production db on both servers
recreate pubs and subs from scripts
restart replication IDEA 2
script pubs on publisher
restore production database on publisher
snapshot changes to subscriber
restart transactional replication Any input would be helpful, THX
I would choose option 1 in order to accomplish the performance and starting from scratch will give benefits. Satya SKJ
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.