March 7, 2006 at 11:06 am
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,
Bill
March 10, 2006 at 4:37 am
A couple of things to look at. I've pasted the message from the dialog below, note that it indicates that AS will only backup metadata in a ROLAP storage based cube, meta data and aggs in HOLAP but it will backup the data, meta data and aggs in a MOLAP cube. So if your cube was MOLAP this backup/restore should have worked.
An alternative approach (and quite possibly a nicer one) is the new Synchornize feature. In SQL Manager, right click on the source AS server in te Object Browser and select Synchronize. This will fire the synch wizard which lets you synchronize meta data and data between two different AS2005 servers. For more info, lookin books on line for this topic -> How to: Synchronize an Analysis Services Database
This is the backup message ->
The dialog will backup metadata for ROLAP partitions, metadata and aggregations for HOLAP partitions, meta data, source data and aggregations for MOLAP partitions. THis is because backup is not applied on the source data contained in the relational database.
Steve.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply