Error in restoring SSAS database

Question

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

 

Answer 1

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.

Answer 2

Hi,

 

Am trying to restore the analysis server database using abf back up. It is giving me following error.

 

 

File System error: System cannot read from the specified device.

 

Please let me know how this can be fixed.

 

Thanks in Advance!

 

Regards,

Pushyamitra