Restoring folder and reports

[Dodecahedron]

Hi,

One of the admin team has managed to delete a folder and all of its reports.

We take a copy of the filestore input and output each night.

If I restore the back up will it restore the folder and reports on the CMS or is there more I need to do.

I am using BOEXIR2

Thanks

 

[groggle]

I take it you mean a folder in Windows under X:\Program Files\Business Objects\BusinessObjects Enterprise 11.5\FileStore where X: is the drive letter of your installation?

IF so, then restoring the folder and its subfolders SHOULD work. I say SHOULD because the entries for the reports SHOULD still be in the CMS database.

The most bullet proof method would be to restore the System Database AND the Input and Output filestores from the same time of backup. This way everything would be back in sync. Of course you will lose ALL reports and instances generated since the backup was performed.

 

[hilfy]

However, if the folder was deleted inside BO, that is MUCH more problematic. I have managed to do it, but it my methods are NOT supported by BO. It required restoring a DB backup to another location AND restoring the files, finding what was in the backup that was deleted from the original and restoring just that data. If you're more than a couple of hours out from when the folder was deleted and you have a lot of reports running, there's a good chance that the CUID's for some of the deleted reports were already reused. In that case, you won't be able to restore those reports.

I DO NOT recommend taking this approach unless you are an expert in your flavor of database and you have good backups before you start because it's very, very easy to mess up your whole system to the point where it's unusable.

-Dell

A computer only does what you actually told it to do - not what you thought you told it to do.