I need to produce a read only, real time copy of a production system for reporting purposes.
So - having reviewed and discounted mirroring, snapshot copies, logshipping etc we were left with one way transactional replication.
This I was able to configure and had working - BUT. Turns out that there were changes needed to the instance that we werent aware of that then generated errors - the one we saw related to the size of lobs exceeding the maximum configured.
This we have fixed, but I would like to ask if there are any more fields / settings that we will need to change in order for the replication to work?