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?