TechNet
Export (0) Print
Expand All
Collapse the table of content
Expand the table of content
Expand Minimize

Remote Partitions - Advanced Settings Dialog Box (Analysis Services - Multidimensional Data)

 

Applies To: SQL Server 2016

Use the Remote Partitions - Advanced Settings dialog box in SQL Server Management Studio to edit advanced settings, such as the connection string of the data source representing the remote Analysis Services database maintaining remote partitions, while restoring remote partitions from a remote backup file to an Analysis Services database by using the Restore Database dialog box. You can display the Remote Partitions - Advanced Settings dialog box from the Partitions page of the Restore Database dialog box by clicking the ellipsis button (...) for a remote partition after selecting the Restore remote partitions option.

TermDefinition
Data source nameDisplays the name of the data source that represents the remote Analysis Services database that manages the listed remote partitions.
Backup fileDisplays the name of the remote backup file that contains the data to be restored for the listed remote partitions. Note that no backup file is displayed if a remote backup file was specified in the Backup file column on the Partitions page of the Restore Database dialog box.
Connection stringDisplays the connection string for the data source displayed in Data source name.
EditClick to display the Data Link Properties dialog box and edit the properties contained in the connection string.
Partitions listSelect to specify different locations in which to restore remote partitions. Note that you can only change the restoration folder of a remote partition if a location other than the default location was specified for that remote partition in the cube. The following items, enabled when this option is selected, is used to specify a restoration folder for each remote partition:

 Cube:
Displays the name of the cube that contains the remote partition.

 MeasureGroup:
Displays the name of the measure group that contains the remote partition.

 Partition:
Displays the name of the remote partition.

 Size (MB):
Displays the size, in megabytes, of the remote partition.

 Original Folder:
Displays the name of the original folder in which the remote partition was stored.

 Restoration Folder:
Type the name of the restoration folder for the remote partition, or click the ellipsis button (...) to display the Browse for Remote Folder dialog box and select the path of the folder to use. For more information about the Browse for Remote Folder dialog box, see Browse for Remote Folder Dialog Box (Analysis Services - Multidimensional Data).

Analysis Services Designers and Dialog Boxes (Multidimensional Data)
Partitions (Restore Database Dialog Box) (Analysis Services - Multidimensional Data)
Backup and Restore of Analysis Services Databases

Community Additions

ADD
Show:
© 2016 Microsoft