This dialog box enables you to:
This dialog box is displayed when in the OLAP Manager tree view you right-click a database and click Archive Database.
The archive file includes files for the selected database that are in a directory named the same as the database. This directory is in the Data directory, which contains a directory for each database on the server. For example, if you archive the FoodMart database, the files in the ...\Data\FoodMart\ directory are included in the archive file. For more information about the Data directory, see “Remote Path” later in this topic.
The archive file also stores metadata for the database and its objects. The appropriate records from the OLAP Services repository are included in the archive file. By default the OLAP Services repository is msmdrep.mdb, but it can be migrated to a SQL Server database.
For more information about archiving OLAP Services databases, see Archive and Restore Databases Add-in.
Specify a file name and extension for the archive file. The extension must be .cab.
Specify the path of the archive file. To browse available paths, click the ... button.
Specify the path of the Data directory that contains the files for the database you are archiving. To browse available paths, click the ... button.
The Data directory is created during installation of Microsoft® SQL Server™ OLAP Services and contains a directory for each database on the OLAP server. The default path of the Data directory is:
..\Program Files\OLAP Services\Data\
The \Program Files\OLAP Services\ portion of the path can be changed. (To determine the current value, right-click the remote server, click Properties, and then see the Data folder box.)
In the Remote Path box, you must precede the path of the Data directory with the remote server name. If the Data directory is shared at its disk level, you must also include the share name associated with the disk. The following example Remote Path value includes the server name Server-1 and the disk share name C$.
\\Server-1\C$\Program Files\OLAP Services\Data\
The Remote Path box appears only if the database you are archiving is on a remote server.
Begins the archive process. The Archive Database Progress dialog box is displayed in which you can monitor or cancel the archive process.
Cancels the archive process.
Displays this Help topic.