You should consider migrating your cubes with one of 2 methods below: 1. Method Backup / Restore (recommended) 2. By copying the DATA directory on the second server while ensuring the SSAS service is stopped on both servers.

Caution

You can not move your cube (SQL Server Analysis Services 2005) via a sync to your new server (SQL Server Analysis Services 2008). If you try, you get the error message: Errors in the OLE DB provider. The server returned the following error: (The BackupLog element at line 1, column 904 (namespace ) cannot appear under Envelope/Body/Execute/Command/InternalSynch.)Backup and restore errors: An error occurred while synchronizing the MyDB' database, Database synchronization failed. . The synchronization works only with the same versions of SQL server and the same service pack level.

Example with the method Backup/Restore:

Step 1 : Backup of the database on the instance SSAS 2005

Method using the Wizard- In Management Studio, connect to your instance SSAS 2005- Click right on database backups- Then click on « Back up… »- Then select the location of the backup file and click OK