We have a mighty 70GB production database but we now need a copy of this database for Analytical Processing. We do have replication setup for some tables to feed in web applications but wanted to know best way to copy entire data from one DB to another.
We would like to refresh data every 24hours. I can manually backup Production database and restore a copy but is not feasible for an everyday task.
Many thanks Dhar
Another avenue that you could head down would be mirroring.
It's like log shipping without the restore outages per se.
It's like replication with fewer restrictions.
You can use it with a Witness server for HA.
And... you can take a snapshot of the mirror for reporting purposes: Database Mirroring and Database Snapshots
answered May 11 '10 at 10:24 AM