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 ?