Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I need advise on what would be the best strategy for backups of OLAP database (WHICH is roughly 500gb in size)

Would this be fine: 1. Weekly (Full) 2. Daily (Differential)

No need to hourly log file back up as data doesn't changes during the day. It only changes when the ETL process is running.

Also current back of 500 gb is taking 9 hours .... I don't know whats going wrong.. is it could be done to ability to write to the RAID drives (means slow throughput). Which tool I can use to verify where the issue is ?


share|improve this question

migrated from Aug 21 '11 at 18:26

This question came from our site for professional and enthusiast programmers.

Is your server limited by CPU or IO when doing backups? Most likely IO in which case enabling backup compression may result in significantly less IO, though at a cost of higher CPU usage. – Mark S. Rasmussen Aug 21 '11 at 18:28
Are you talking about backing up OLAP cubes in SQL Server Analysis Services or backup in a datawarehouse database in SQL Server. – mrdenny Aug 21 '11 at 19:57
What's "the best" strategy? That's a subjective question which will garner subjective answers. What's best for me may not be best for you. How about taking the time to give is details on your recovery requirements, which ostensibly should be driven by the business needs. – joeqwerty Aug 21 '11 at 21:16

Depends on what you need, you know. FOr example, I am in a project where we have a possibly 21.000 gb olap database that does get rebuild but is not really backed up - we maintain the base data. Plus 2live servers with the data warehouse. If something fails we rebuild it from the enterprise schema.

Also current back of 500 gb is taking 9 hours

Get more appropriate hardware. Maybe not a usb hard disc ;)

SQL Server can wonderfully handle RAID backup to multiple mediums at the same time.

But really, you need a LOT more data for an answer to even make sense.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.