INF: File Size Limitations For Use of Archive/Restore for OLAP (303415)


The information in this article applies to:

  • Microsoft SQL Server OLAP Services 7.0
  • 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.

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

Modification Type:MajorLast Reviewed:6/25/2004
Keywords:kbinfo KB303415
©2004 Microsoft Corporation. All rights reserved.