Hello, Hopefully I have posted this in the right forum. We have transactional replication setup between a box in the U.S and a box in the UK as a push subscription from the U.S. The database in question is approx 100GB in size and growing fast. I'd like to setup a DR environment in case the UK box goes down. I was thinking of setting up a mirrored database on the subscribed database and in the event the database goes down the mirrored database could take over. My question is, from within replication, can the publisher be redirected to point at the mirrored database rather than the orginal database easiley, without having to setup a new subscriber, snapshot etc. If this is possible, can you see any pitfalls? Thanks for your help.