Remote Server Data Directory Dialog Box

This dialog box enables you to confirm or change the path of the Data directory to which a Microsoft® SQL Server™ OLAP Services database will be restored.

This dialog box is displayed when in the OLAP Manager tree view you right-click a remote server and click Restore Database.

For more information about restoring OLAP Services databases, see Archive and Restore Databases Add-in.

Options

Path

Specify the path of the Data directory that will contain the files for the database after the restoration is complete.

The Data directory is created during installation of Microsoft® SQL Server™ OLAP Services and contains a directory for each database on the OLAP server. The default path of the Data directory is:

..\Program Files\OLAP Services\Data\

The \Program Files\OLAP Services\ portion of the path can be changed. (To determine the current value, right-click the remote server, click Properties, and see the Data folder box.)

In the Path box, you must precede the path of the Data directory with the remote server name. If the Data directory is shared at its disk level, you must also include the share name associated with the disk. The following example Path value includes the server name Server-1 and the disk share name C$.

\\Server-1\C$\Program Files\OLAP Services\Data\

Browse

Displays a dialog box in which you can browse available paths and select one.

OK

Selects the path in the Path box and continues the restoration procedure.

If OK is dimmed, the path in the Path box is invalid or you do not have authorization to access it.

Cancel

Cancels the restoration.

Help

Displays this Help topic.

(c) 1999 Microsoft Corporation. All Rights Reserved.