• Good Morning....

    thanks for the comment.

    You could use Trnxn-Replication to copy the data to your staging server and then SSIS to ETL the data from the staging server to you reporting DB.

    Mirroring could work too, depending on exact requirements and how often you wanteed to back up your transaction logs.

    Hope this helps...

    GAJ

    Gregory A Jackson MBA, CSM