October 13, 2009 at 7:29 am
What's the best way to replicate my DB in this senario?
I have a Db that I need to replicate out for reporting purposes. I tried letting my users hit on the production DB but it was too much for the DB to handle, temp DB would fill.
So, I need a copy of my production DB so my users can run ad hoc reports against it. New data gets inserted in a batch import process once a day and then new data is also inserted/updated thoughout the day.
Whats' the best way to replicate out my DB?
October 13, 2009 at 7:40 am
Well if you are going down the replication route, you could use either transactional or merge, probably better to use transactional uni-directional replication to your replicated/reporting database
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]
October 13, 2009 at 7:40 am
The best way really depends on your setup and how up-to-date you need the reporting database to be,
If you require up-to-date data then you could use transactional replication to send the data to the reporting database everytime data is added.
Otherwise you could look at using SSIS to copy the data over at regular intervals, the advantage of this method is that it allows you to transform the data into a form that could be better suited for reporting.
Another alternative would be to restore your latest backup to your reporting server.
Also, I have been playing around with virtual database beta from Idera for our reporting solution , this allows you to query directly from your backups without restoring, though this would cost money it may work for you.
October 13, 2009 at 7:52 am
thanks everyone..
October 13, 2009 at 7:56 am
there is also log shipping and database snapshots you could throw into the mix as potentials
If you want to replicate virtually all your database objects then log shipping with standby is a good option, otherwise i would personally just look at transactional replication of the objects needed.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply