Home Forums Data Warehousing Strategies and Ideas How often do you back-up your data warehouse? RE: How often do you back-up your data warehouse?
prescientdba
SSC Veteran
Points: 268
More actions
February 14, 2013 at 6:58 am
#1587896
We do a nightly backup before the ETL load as well. Just for reference, we use Idera SQL Safe backup software for all SQL databases. It has superior compression (up to 90% compression) to the native SQL backup.