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:
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.
REFERENCES
For additional information, click the article number below to view the article in the Microsoft Knowledge Base:
249698 FIX: OLAP Addins: Archive Fails with More than 2 GB of Data
Additional query words: Archive Restore CAB OLAP
Keywords: kbinfo KB303415