• We have mirroring on another server and a snapshot as part of high availability. Snapshot is taken every 12 hours. But snapshot takes more physical reads than the production database. I am yet to see how it works. Understand that the first time run will take more time and from second run onwards it will be fine.

    Will check it.

    ______________________________________________________________Every Problem has a Solution; Every Solution has a Problem: 🙂