Archiving an OLAP Services Database

You can archive a Microsoft® SQL Server™ OLAP Services database by using the OLAP Manager or the msmdarch command.

To archive an OLAP Services database using the OLAP Manager, use the Archive Database and Archive Database Progress dialog boxes.

To archive an OLAP Services database with the OLAP Manager

  1. In the OLAP Manager tree view, right-click a database, and then click Archive Database.
  2. In the Archive Database dialog box, specify a file name and path for the archive file. If you are archiving a database on a remote server, you must also specify the path of the Data directory containing the files for the database. Click Archive.
  3. In the Archive Database Progress dialog box, monitor the progress of the archive process. You can cancel the archive process after it has begun. You can also save the archive log.

To archive an OLAP Services database using the msmdarch command, you can use the Command Prompt window.

To archive an OLAP Services database with the msmdarch command

  1. On your desktop click Start, point to Programs, and then click Command Prompt.
  2. (Optional.) Use the cd command to access the directory containing the msmdarch.exe file. By default, this file is at the following location:

    ..\Program Files\OLAP Services\Bin\

  3. Type a valid msmdarch command with the /a switch. The full syntax and an example are shown below.
  4. Press ENTER.

You can also execute the msmdarch command from a .bat file. If you want to schedule execution of a .bat file, it is recommended that you use Data Transformation Services.

Syntax

["command-path]msmdarch["]    /a    server    "data-path"    "database-name"    "archive-path-and-file-name"    ["log-path-and-file-name"]

command-path
The path containing the msmdarch.exe file. By default, this path is:

\Program Files\OLAP Services\Bin\

server
The server computer name that contains the database you want to archive.
data-path
The path of the Data directory that contains the files for the database you want to archive. By default, this path is:

\Program Files\OLAP Services\Data\

database-name
The name of the database you want to archive.
archive-path-and-file-name
The path, file name, and .cab extension of the archive file.
log-path-and-file-name
The path, file name, and .log extension of the archive log. If you specify an archive log that already exists, the new archive log is appended to it. If you specify an invalid path or file name, the archive log is written to the \Bin\DBArchive.log file, which by default is ..\Program Files\OLAP Services\Bin\DBArchive.log.
Example

The following command archives the sample FoodMart database included in OLAP Services.

"\Program Files\OLAP Services\Bin\msmdarch" /a myserver "\Program Files\OLAP Services\Data\" "FoodMart" "\My archives\server myserver\FoodMart.cab"

 

(c) 1999 Microsoft Corporation. All Rights Reserved.