Hello,
I'd love to hear from anyone that deals with setting up Transaction Replication in their test environment. I am willing to bet that most of you take a production backup (if so, how, and using what?), restoring the database to your test environment, then running a snapshot to your subscriber and away you go.
But perhaps you take a backup of your publisher and subscriber, if so, how do you know there are no inconsistences because there were transactions sitting on the distributor?
What do you do if you have additional indexes on the subscriber for reporting, that are not on the publisher?
I love to hear all your experiences. Here at work we are having issues with getting consistent databases set up with T Rep, missing rows, duplicate keys at subscriber etc. What kind of things do you guys and gals do out there to avoid these issues?
An average how long does your method take you?
Thanks for reading, I'm really interested to see what comes back. And thank you again.
Regards,
D.