[SQL Server Data Warehousing] Recovery model for DWH databases

thanks Kieran and mike.

We have ETLs which run throught out the night and populate data in Daawarehouse and dartmart dbs and ETLs will not run during the Day time. The database size will be around 300GB for earch DB. As mike said, we can take fulll backup of the DBs but in our case, we are in processin of designing a DR strategy for DWH databases and so transferring the full backup over the network is not feasable (even after compression enabled), hence we are planning for a weekly fulls and daily differential with simple recovery model...

what is your opinion on this solutuin or you can suggest some alternate plans...

Thanks for the help

.

social.technet.microsoft.com/Forums

[SQL Server Data Warehousing] Recovery model for DWH databases

thanks Kieran and mike.

We have ETLs which run throught out the night and populate data in Daawarehouse and dartmart dbs and ETLs will not run during the Day time. The database size will be around 300GB for earch DB. As mike said, we can take fulll backup of the DBs but in our case, we are in processin of designing a DR strategy for DWH databases and so transferring the full backup over the network is not feasable (even after compression enabled), hence we are planning for a weekly fulls and daily differential with simple recovery model...

what is your opinion on this solutuin or you can suggest some alternate plans...

Thanks for the help

.

social.technet.microsoft.com/Forums

[SQL Server Data Warehousing] Recovery model for DWH databases

thanks Kieran and mike.

We have ETLs which run throught out the night and populate data in Daawarehouse and dartmart dbs and ETLs will not run during the Day time. The database size will be around 300GB for earch DB. As mike said, we can take fulll backup of the DBs but in our case, we are in processin of designing a DR strategy for DWH databases and so transferring the full backup over the network is not feasable (even after compression enabled), hence we are planning for a weekly fulls and daily differential with simple recovery model...

what is your opinion on this solutuin or you can suggest some alternate plans...

Thanks for the help

.

social.technet.microsoft.com/Forums

[SQL Server Data Warehousing] Recovery model for DWH databases

thanks Kieran and mike.

We have ETLs which run throught out the night and populate data in Daawarehouse and dartmart dbs and ETLs will not run during the Day time. The database size will be around 300GB for earch DB. As mike said, we can take fulll backup of the DBs but in our case, we are in processin of designing a DR strategy for DWH databases and so transferring the full backup over the network is not feasable (even after compression enabled), hence we are planning for a weekly fulls and daily differential with simple recovery model...

what is your opinion on this solutuin or you can suggest some alternate plans...

Thanks for the help

.

social.technet.microsoft.com/Forums

[SQL Server Data Warehousing] Recovery model for DWH databases

thanks Kieran and mike.

We have ETLs which run throught out the night and populate data in Daawarehouse and dartmart dbs and ETLs will not run during the Day time. The database size will be around 300GB for earch DB. As mike said, we can take fulll backup of the DBs but in our case, we are in processin of designing a DR strategy for DWH databases and so transferring the full backup over the network is not feasable (even after compression enabled), hence we are planning for a weekly fulls and daily differential with simple recovery model...

what is your opinion on this solutuin or you can suggest some alternate plans...

Thanks for the help

.

social.technet.microsoft.com/Forums

[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

[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