Remote Server Data Directory Dialog Box

Analysis Services

Analysis Services

Remote Server Data Directory Dialog Box

Use this dialog box to confirm or change the path of the Data directory to which a Microsoft® SQL Server™ 2000 Analysis Services database will be restored.

For more information about restoring Analysis Services databases, see Archiving and Restoring Databases.

This dialog box is displayed when, in the Analysis Manager tree pane, you right-click a remote server and then click Restore Database.

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 Analysis Services and contains a directory for each database on the Analysis server. The default path of the Data directory is:

C:\Program Files\Microsoft Analysis Services\Data\

You can change the \Program Files\Microsoft Analysis Services\ portion of the path. (To determine the current path, right-click the remote server, click Properties, and then 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\Microsoft Analysis Services\Data\

Browse

Click to display a dialog box in which you can browse available paths and select one.

OK

Click to select the path in the Path box and continues the restoration procedure.

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