How to archive an Analysis Services database using the msmdarch command
To archive a Microsoft® SQL Server™ 2000 Analysis Services database using the msmdarch command
- Open a command prompt.
- (Optional.) Use the cd command to access the directory containing the msmdarch.exe file. By default, this file is at the following location:
C:\Program Files\Microsoft Analysis Services\Bin
- Type a valid msmdarch command with the /a switch. The full syntax and an example are shown later in this topic.
- Press ENTER.
Note You can use the /? switch to display a help window that shows the syntax of the switches.
Syntax
["command-path]msmdarch["] /a Server "OLAPDataPath" "DatabaseName" "BackupFileName" ["LogFileName" ["TempDirectory"]]
command-path
The path containing the msmdarch.exe file. By default, this path is:
C:\Program Files\Microsoft Analysis Services\Bin
Server
The server computer name that contains the database you want to archive.
OLAPDataPath
The path of the Data directory that contains the files for the database you want to archive. By default, this path is:
C:\Program Files\Microsoft Analysis Services\Data
DatabaseName
The name of the database you want to archive.
BackupFileName
The path, file name, and .cab extension of the archive file.
LogFileName
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 DBArchive.log file, which by default is C:\Program Files\Microsoft Analysis Services\Bin\DBArchive.log.
TempDirectory
The specified path of the temporary directory used for processing space. This option must be specified if LogFileName is specified.
Example
The following command archives the sample FoodMart 2000 database included in Analysis Services.
"\Program Files\Microsoft Analysis Services\Bin\msmdarch" /a myserver
"\Program Files\Microsoft Analysis Services\Data\" "FoodMart 2000"
"\My archives\server myserver\FoodMart 2000.cab"