Good day everybody.

I'm having an issue with Cubes on our Data Warehouse server. They crashed and thus SQL crashed. I was able to get SQL working again by restoring a backup from some time ago. The issue I have now is that all the Facts from January, 2013 till present are missing on each of the Measure Groups.  Is there an easy was to restore all of the missing Facts without have to script out each individual one, change the month and date range then importing back? 

Thank you to any and all who can help.

Andrew Gordon

Systems Administrator

Eastern Institute of Technology

Taradale, New Zealand