Wednesday, April 17, 2013

[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

No comments:

Post a Comment

Search This Blog