backup problem

I successfully deployed the AdventureWorks OLAP database to my 2005 Analysis Server and Backed it up under SQL Server Management Studio. When I tried to restore the backup to another sql 2005 Analysis Server the restore failed.

I went back to the "Backup" dialog box and noted that it would only "store database metadata to a specific location". Metadata only? How do I create a full backup that can be restored on another server and is ready for use?

TIA,

Barkingdog

Hi Barkingdog,

You should be able to backup AdventureWorks and restore it to another server. Can you let me know of what is the failure message when you restore the database on another server?

Yan Li

|||What is the storage mode used for your cube - if you are using ROLAP or HOLAP, the cube data is not backed up because cube data remains in the underlying data source - for all data and meta data to be backed up in the AS backup file in AS2K5, you must be using MOLAP are your storage mode.