Archive Database Dialog Box
Use this dialog box to:
- Specify options for archiving a Microsoft® SQL Server™ 2000 Analysis Services database.
- Begin the archive process, which produces an archive file.
The archive file includes files for the selected database that are in a directory with the same name 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 2000 database, the files in C:\Program Files\Microsoft Analysis Services\Data\FoodMart 2000\ are included in the archive file.
Important The subdirectories of the Data directory store the security files that control end users' access to objects on the Analysis server. These files are included in the archive files. For this reason, archive files must be secured against unauthorized access.
The archive file also stores meta data for the database and its objects. The appropriate records from the Analysis Services repository are included in the archive file. By default, the Analysis Services repository is Msmdrep.mdb, but it can be migrated to a SQL Server database.
For more information about archiving Analysis Services databases, see Archiving and Restoring Databases.
The dialog box is displayed when, in the Analysis Manager tree pane, you right-click a database and then click Archive Database.
Specify the name and path of the archive file. To browse available paths, click the browse (...) button.
Specify the directory in which to store temporary files during the archive process. To browse available paths, click the browse (...) button.
Specify the path of the Data directory that contains the files for the database you are archiving. To browse available paths, click the expand (...) button.
The Data directory is created during installation of Analysis Services and contains a directory for each database on the Analysis server. The default path of the Data directory is C:\Program Files\Microsoft Analysis Services\Data\
The C:\Program Files\Microsoft Analysis Services\ portion of the path can be changed. (To determine the current value, right-click the remote server, click Properties, and then view 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\Microsoft Analysis Services\Data\
The Remote Path box appears only if the database you are archiving is on a remote server.
Begin the archive process. The Archive Database Progress dialog box is displayed, and it allows you to monitor or cancel the archive process.