While ago I reply to a thread regarding this issue, see http://www.sqlmonster.com/Uwe/Forum.aspx/sql-server-olap/11643/Backing-up-databases-with-large-partitions-in-AS2005. I think the original forum is no longer available.
This week I got a similar problem, now we are not able to create and restore a
abf for a cube with a .fact.data file with size of 4.39 GB.
We are in a Win Server 2003 Enterprise Edition SP2 (IA64) . The SSAS version is 9.00.4035.00 (SQL Server 2005 Service Pack 3 ).
We did the following steps:
Create the .abf in SSMS compressing the data of the <database name>_2010 .
Restore it in the same server with the name <database name>_201008 .
We are not able to browse the cube in <database name>_201008 .
If we unprocess the partition with the .fact.data with size of 4.39 GB, then the cube browses without problems.
We then copy the .fact.data from the <database name>_2010 to
<database name>_201008 and then the cube from <database name>_201008 browses correctly!
I can add that the database was processed in Win Server 2003 Enterprise Edition SP2 (x86) (with
SQL Server 9.00.3228.00 - Cumulative update package 6 for SQL Server 2005 Service Pack 2 ) and then synchronized to the
Win Server 2003 Enterprise Edition SP2 (IA64) (also 9.00.3228.00) without problems.
In the original thread Peter Yang [MSFT] stated th
View Complete Post