Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
BravehearT1326
Starting Member
24 Posts |
 Posted - 2009-11-19 : 09:56:06
|
| 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 browseryou 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. |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2009-11-19 : 10:16:27
|
"Physical file \\?\D:\<path to file>"is this a mix of UNC-path and driveletter-path?
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
BravehearT1326
Starting Member
24 Posts |
Posted - 2009-11-19 : 10:44:29
|
| Hi - That's the actual error message that is produced. I was assuming that the \\? was supposed to be the server name but could be wrong. |
|
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2009-11-19 : 10:49:00
|
That was my point.It can be: \\server\<path to file>It can be: D:\<path to file>But never a mix of them.I don't know where to find this property in your case - sorry - but it looks like there is a mistake...
No, you're never too old to Yak'n'Roll if you're too young to die. |
|
|
|
BravehearT1326
Starting Member
24 Posts |
|
|
BravehearT1326
Starting Member
24 Posts |
Posted - 2009-11-19 : 11:26:01
|
| The full error shown in the cube browser is:The query could not be processed:o File system error: The following file is corrupted: Physical file: \\?\d:\SSASDATA\SSAS\Data\My SDA Cubes.28.db\My Data Mart.24.cub\Fact Performance.26.det\Fact Performance.26.prt\94.fact.data. Logical file . |
|
|
|
BravehearT1326
Starting Member
24 Posts |
Posted - 2009-11-19 : 11:32:37
|
| Looks like the issue could be that one of the partitions is over 2GB in Size. Apparently there is a limit on SQL2005.....?? Anyone know if there's a hotfix for it |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2009-11-19 : 12:20:58
|
| saw this? http://blogs.msdn.com/sqlcat/archive/2009/03/13/analysis-services-partition-size.aspx |
|
|
|
|
|
|
Corrupt file error after backup and restore of Cub