Hi there - got an issue with the backup and restore of a cube from one machine to another. Issue is as follows:
Cube sits and is processed on SERVER_A without any issues and can be browsed quite happily. The cube is approx 9.5GB in size after processing.
The cube is then backed up using encryption and copied over to another machine which has the same level of Analysis Services installed (9.00.3054.00) and then restored. The cube restores successfully however when browsing it using cube browser you receive the following message:
"The query could not be processed: File system error. The following file is corrupted: Physical file \\?\D:\<path to file>"
In order to get the cube onto the new machine and working again it has to be re-processed on the new server.
Anyone seen this issue before and know what causes it - its driving me crazy and does not affect ALL cubes backed up and restored in this way as others work fine.
Thanks for help in advance.