• For reporting, mirroring with database Snapshots is an option you should consider. You will need to recreate your Snapshot(s) on a regular cycle (depending on your requirements). You may be able to use a cyclical snapshot schema - snp_DB1, then x minutes later snp_DB2, etc over a period, to mitigate lost connection issues, or you may have to drop the connections when you recreate the snapshot(s).