Friday, March 9, 2012

restore analyse backup from developer edition to standard edition

I did a backup of an analyse service database (cube) on my developer edition of analyse service.(developer machine)

This backup I tried to restore on a standard edition of analyse service. (production machine)

error:

Errors related to feature availability and configuration: The 'Perspectives' feature is not included in the 'Standard Edition' SKU.

Errors in the metadata manager. An error occurred when loading the nr2 perspective, from the file, '\\?\C:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\Data\sj cube 1.17.db\Sj Mp2.49.cub\Perspective.22.persp.xml'.

Errors in the metadata manager. An error occurred when loading the Sj Mp2 cube, from the file, '\\?\C:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\Data\sj cube 1.17.db\Sj Mp2.51.cub.xml'.

(Microsoft.AnalysisServices)

I then tried to delete it, but the same error message.

How to delete this ?

It hurts because you get this message generelly. Not only for this database. No restore/backup of other databases can be done.

BOL quote:

It includes all of the functionality of SQL Server 2005 Enterprise Edition, but is licensed for use as a development and test system, not as a production server. SQL Server 2005 Developer Edition is an ideal choice for independent software vendors (ISVs), consultants, system integrators, solution providers, and corporate developers who build and test applications. You can upgrade SQL Server 2005 Developer Edition for production use.

I believe the error is by default due to the configuration of Standard Edition and mismatch with the features availabel with Developer edition. You might report this to the Microsoft Connect for more information.

No comments:

Post a Comment