What is the size of your DW, and how long does the backup and the restore take? I would be concerned that as your DW size grows, you may run out of time to do the backup/restore cycle.
What are your thoughts on using a SQL 2005 database snapshot in place of the backup/restore.
Original author: SQL Server FineBuild 1-click install and best practice configuration of SQL Server 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005. 1 Dec 2016
: now over 39,000 downloads.
Disclaimer: All information provided is a personal opinion that may not match reality.
Quote: "When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist." - Archbishop Hélder Câmara