Wednesday, March 7, 2012

Restore of a Database in Analysis Server Failure

Hi Everyone,

We have an Analysis Services database which has 9 cubes. Whenever I do an Archive/Restore it fails giving the following error:

* Unexpected error encountered while updating repository item cannot be found in the collection corresponding to the requested name or ordinal.
* Restoration Cancelled
* DSO function failed

Please advise.

Regards,
Kalyanis your repository in access or in sql server? if you migrated it to sql server and your repository is corrupted you can get it back. however if it is in the access db you may have a different outcome than you wish.
have you tried to restore your cube to another AS to see if the backup is corrupted>?

No comments:

Post a Comment