Restoring an OLAP Services Database

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

To restore an OLAP Services database with the OLAP Manager, use the Open Archive File, Restore Database, and Restore Database Progress dialog boxes. If you are restoring a database on a remote server, you must also use the Remote Server Data Directory dialog box.

To restore an OLAP Services database with the OLAP Manager

  1. In the OLAP Manager tree view, right-click a server, and then click Restore Database.
  2. If you are restoring a database on a remote server, the Remote Server Data Directory dialog box appears. Specify the path of the Data directory to which the database will be restored. This directory will contain the files for the database after the restoration is complete. Click OK.
  3. In the Open Archive File dialog box, specify the path and file name of the archive file, and then click Open.
  4. In the Restore Database dialog box, click Restore.
  5. In the Restore Database Progress dialog box, monitor the progress of the restoration. You can cancel the restoration after it has begun. You can also save the restore log.

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

To restore an OLAP Services database using 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 /r 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["]    /r    server    "data-path"    "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 to which you want to restore the database.
data-path
The path of the Data directory that will contain the files for the database after the restoration is complete. By default, this path is:

\Program Files\OLAP Services\Data\

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 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 \Bin\DBRestore.log file, which by default is ..\Program Files\OLAP Services\Bin\DBRestore.log.
Example

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

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

 

(c) 1999 Microsoft Corporation. All Rights Reserved.