[SQL Server Data Warehousing] Recovery model for DWH databases

Using Recovery Model (Simple) and relying on a mixture of say differential backups during the week and full backups once a week can very significantly reduce maintainance overhead especially when the data warehouse reaches many gigbytes in size. If as Mike says the data warehouse is not populated with new data outside the nightly ETL. So I find in practice if you perform a backup immediately after your perform your ETL you have the most optimised solution in most scenarios.

http://msdn.microsoft.com/en-us/library/ms175987(v=sql.105).aspx

Kind Regards,

Kieran.

---

If you have found any of my posts helpful then please vote them as helpful. Kieran Patrick Wood MCTS BI, PGD SoftDev (Open), MBCS http://www.innovativebusinessintelligence.com http://uk.linkedin.com/in/kieranpatrickwood

.

social.technet.microsoft.com/Forums