Restoring Data-warehouse

James_Johnson

I had to restore our DW to a backup due to some corruption issues. The only database I did was the DWDataMart. Does anyone know how to tell the system that it needs to resync data between when the backup was done and the date the backup was made? The jobs are running now and data is being transferred it's just skipping the data in between.

Also I'm getting some errors saying "DWDataMart (primary datamart) being out of sync from other marts" would it be best just to restore all of the other databases to the same time as the DWDataMart as well or is there an easier way to sync it back up?

Thanks,

James

Brian_Wiest

When restoring you must restore all Data Warehouse DB's to the exact point in time. We had done it many times and it works. You cannot do one due to the way the ETL process works. Here is a link to a diagram showing the process.

https://msdnshared.blob.core.windows.net/media/TNBlogsFS/prod.evol.blogs.technet.com/CommunityServer.Blogs.Components.WeblogFiles/00/00/00/62/41/metablogapi/3056.image_thumb_67D803C2.png

HTH

Brian_Wiest

When restoring you must restore all Data Warehouse DB's to the exact point in time. We had done it many times and it works. You cannot do one due to the way the ETL process works. Here is a link to a diagram showing the process.

https://msdnshared.blob.core.windows.net/media/TNBlogsFS/prod.evol.blogs.technet.com/CommunityServer.Blogs.Components.WeblogFiles/00/00/00/62/41/metablogapi/3056.image_thumb_67D803C2.png

HTH

James_Johnson

Thanks, @Brian_Wiest

Restoring all of them did the trick.