This dialog box enables you to begin the restoration of a Microsoft® SQL Server™ OLAP Services database.
This dialog box is displayed when in the Open Archive File dialog box you click Open.
Caution When you restore a database, its file set (in the Data directory and its subdirectories) and its metadata are returned to their states at the time the archive file was created. Files that were created since then in these directories are deleted. Changes and additions since then to OLAP Services repository records for the database and it objects are removed.
The restoration of a database overwrites the contents of the directory used by the database. The files in this directory are overwritten by the files in the archive file you selected in the Open Archive File dialog box. Files that were added to this directory since the archive file was created are deleted. This directory is named the same as the database and is in the Data directory, which contains a directory for each database on the server. For example, if you restore the FoodMart database, the contents of the ...\Data\FoodMart\ directory (and its subdirectories) are overwritten. The default path of the Data directory is:
..\Program Files\OLAP Services\Data\
The path leading to the Data directory can be changed. (To determine the current path, in the OLAP Manager, right-click the server that contains the database you are restoring, click Properties, and then see the Data folder box.)
When you restore a database, the records in the OLAP Services repository that are associated with the database and its objects are replaced by the OLAP Services repository records in the archive file you selected. By default the OLAP Services repository is:
..\Program Files\OLAP Services\Bin\msmdrep.mdb
However, the path of the repository can be changed at installation, and the repository can be migrated to a SQL Server database.
For more information about restoring OLAP Services databases, see Archive and Restore Databases Add-in.
Begins the restoration. The Restore Database Progress dialog box, in which you can monitor or cancel the restoration, is displayed.
Cancels the restoration.
Displays this Help topic.