• I actually started with transactional but then I got worried about identity ranges so I switched to merge instead to utilize the automatic identity range management. Log shipping is more familiar territory for me, but the big requirement on this project is that the application can switch to the DR database without any manual intervention.

    I've got a bit more time for experimentation so I might try some other options. Thanks very much for your comments Chris.