SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On



Corrupt file error after Analysis Services backup and restore when... Expand / Collapse
Author
Message
Posted Thursday, November 19, 2009 7:51 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, March 17, 2010 5:02 AM
Points: 2, Visits: 117
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 (SERVER_B) 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.
Post #821624
« Prev Topic | Next Topic »


Permissions Expand / Collapse