How to restore an Analysis Services database using the msmdarch command

To restore a Microsoft® SQL Server™ 2000 Analysis Services database using the msmdarch command

1. Open a 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:

   C:\Program Files\Microsoft Analysis Services\Bin

3. Type a valid msmdarch command with the /r or /rs switch. The full syntax and an example are shown later in this topic.
   
   
4. Press ENTER.

Note  You can use the /? switch to display a Help window that shows the syntax of the switches.

Syntax

["command-path]msmdarch["] switch Server "OLAPDataPath" "BackupFileName" ["LogFileName" ["TempDirectory"]]

command-path

(Optional.) The path containing the msmdarch.exe file. By default, this path is:

C:\Program Files\Microsoft Analysis Services\Bin

switch

Specifies the option to be used when executing the command. The /r switch is used to specify a regular restoration, which will overwrite the database if it exists. The /rs switch is used to restore the database from the archive file only if the database does not exist already.

Server

The server computer name to which you want to restore the database.

OLAPDataPath

The path of the Data directory that will contain the files for the database after the restoration is complete. By default, this path is:

C:\Program Files\Microsoft Analysis Services\Data

BackupFileName

The path, file name, and .cab extension of the archive file.

LogFileName

The path, file name, and .log extension of the restore log. If you specify a restore log that already exists, the new restore log is appended to it. If you specify an invalid path or file name, the restore log is written to the DBRestore.log file, which by default is C:\Program Files\Microsoft Analysis Services\Bin\DBRestore.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 restores the sample FoodMart 2000 database included in Analysis Services.

"\Program Files\Microsoft Analysis Services\Bin\msmdarch" /r myserver 
"\Program Files\Microsoft Analysis Services\Data\" 
"\My archives\server myserver\FoodMart 2000.cab"

See Also

Restoring an Analysis Services Database