Copy Production DB to another DB for OLAP processing


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.

Please advise.

Many thanks Dhar

more ▼

asked May 10, 2010 at 04:23 PM in Default

Dhar gravatar image

11 1 1 1

(comments are locked)
10|1200 characters needed characters left

6 answers: sort voted first

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

more ▼

answered May 11, 2010 at 10:24 AM

Blackhawk-17 gravatar image

11.9k 28 31 37

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: May 10, 2010 at 04:23 PM

Seen: 2140 times

Last Updated: May 10, 2010 at 04:26 PM