Microsoft KB Archive/303415

= INF: File Size Limitations For Use of Archive/Restore for OLAP =

Article ID: 303415

Article Last Modified on 2/22/2007

-

APPLIES TO


 * Microsoft SQL Server OLAP Services
 * Microsoft SQL Server 2000 Analysis Services

-



This article was previously published under Q303415



SUMMARY
The Archive/Restore utility allows you to back up an OLAP database and the associated cube, dimension, and other structures for restoration on the same or a different OLAP server. The Archive/Restore utility is an optional add-in for OLAP Manager provided with SQL Server 7.0. For SQL Server 2000, the add-in is automatically installed in Analysis Manager.



MORE INFORMATION
The data files and metadata for the selected OLAP database are compressed and stored with the Cabinet (CAB) format. Individual CAB files cannot exceed 2 * (10^9) bytes in size, due to a limitation with the CAB storage algorithm. As a result, any single OLAP data file cannot exceed 2 * (10^9) bytes in size when you use the Archive/Restore utility. If a data, map, partition, dimension or other file in an OLAP database exceeds 2 * (10^9) bytes, the archive utility displays this error message:

One of the data files is too large to be stored inside a CAB file.

If the total size of all files to be included in the archive is greater than 2 * (10^9) bytes, but no one file is greater than 2 * (10^9) bytes in size, multiple CAB files are created by the Archive utility.

NOTE: A bug exists in the early releases of the add-in for OLAP Services 7.0, which prevented the file size checks from working prior to SQL Server 7.0 Service Pack 2.