Monday, March 19, 2012

Error in restoring SSAS database

Hi,

getting this error on restoring an ssas database .abf file with a different database name.
Backup and restore errors: Restore under different DatabaseId/DatabaseName can not be done for a database with partitions with specific location.
(Microsoft.AnalysisServices)

Program Location:

at Microsoft.AnalysisServices.AnalysisServicesClient.SendExecuteAndReadResponse(ImpactDetailCollection impacts, Boolean expectEmptyResults, Boolean throwIfError)

The db from which the backup was created had its partition data outside of the cube specific folder
....\Program Files\Microsoft SQL Server\MSSQL.1\OLAP\Data\XYZ.cub
That is the partition data was in the root folder ...\Data in the guid named folders.
Also tried changing the location for the partitions during the restore.

Is this an Analysis Services limitation?

Regards

That is correct.

The current limitation is: you cannot restore database with different name if you have partitions not in default location.

Edward Melomed.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

No comments:

Post a Comment