x

Copy Production DB to another DB for OLAP processing

Hello

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

Dhar
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

Blackhawk-17
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.

Follow this question

By Email:

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

By RSS:

Answers

Answers and Comments

SQL Server Central

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

Topics:

x84
x7

asked: May 10, 2010 at 04:23 PM

Seen: 2164 times

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