I have 2 servers Production and Reporting and I'm looking to set up transactinal replication between the 2 servers
Production Server will be the publisher.
Report Server wil hold the distribution and subscription.
Replication all files in real time.
From what i've seen it all looks reasoanbly straigh forward, which always makes me nervous.
What are the favoutite "Traps" that are going to pop up and bite me when I come to do this?
Any advice etc would be great.
I love deadlines. I like the whooshing sound they make as they fly by
Douglas Adams
(1952-2001)