HI there I would like to ask the experts about the following:
We have a SQL 2005 server, running a Dynamics Axapta database. Understandibly uptime and continuity is crucial. The databse is roughly about 300GB.
I need to do the following:
Any suggestions will be much appreciated.
As far as I know, Log shipping and reporting does not go well together. One will be blocking the other from doing its job.
Also consider doing a proper Data Warehouse for your reporting requirements. It's more work, but your reports will perform. I can recommed reading Ralph Kimball; The Data Warehouse toolkit.
answered Jan 08 '10 at 11:28 AM
Henrik Staun Poulsen
A few things of note...
"I also need to have the significant transaction logs just incase we missed something on the transaction logs."
This means you need ALL the transaction log backups.
If you're using your DR box for reporting, it'll need a licence. Also, decide how frequently you want to be restoring the transaction logs onto that machine, if you only want your reports updated daily.
Don't backup your database directly to removable storage. Back it up to a disk somewhere, and then copy the backup to removable storage. If you need it, you don't want to have to locate it first.
But absolutely, read whitepapers on High Availability. Go check out Paul Randal's material for lots more information - he's generally the guy on that topic.
answered Jan 03 '10 at 09:46 PM
I am not entirely sure what the question is, but here are a few thoughts I have on your goals.
answered Jan 03 '10 at 01:35 PM