• mirroring or transactional replication could be possible solution here but first database size and transaction frequency should be revealed here.

    -------Bhuvnesh----------
    I work only to learn Sql Server...though my company pays me for getting their stuff done;-)