Partitions (Restore Database Dialog Box) (SSAS)
Use the Partitions page of the Restore Database dialog box in SQL Server Management Studio to specify the location to restore local partitions, and to specify whether to restore remote partitions and the remote backup files to use when restoring remote partitions.
Options
Term
Definition
Restore to original locations
Select to restore local partitions contained in the backup file to their original locations.
Select different locations
Select to specify different locations in which to restore local partitions.
.gif "ms178307.note(en-US,SQL.90).gif")
Note:
You can only change the restoration folder of a local partition if a location other than the default location was specified for that partition in the cube.
The following grid, enabled when this option is selected, is used to specify a restoration folder for each local partition:
Column
Description
CubeDisplays the name of the cube that contains the local partition.
MeasureGroupDisplays the name of the measure group that contains the local partition.
PartitionDisplays the name of the local partition.
**Size (MB)**Displays the size, in megabytes, of the local partition.
Original FolderDisplays the name of the original folder in which the local partition was stored.
Restoration FolderType the name of the restoration folder for the local 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 (SSAS).
Restore remote partitions
Select to restore remote partitions stored in remote backup files.
Note:
This option is enabled only if the backup file contains references to remote partitions.
The following grid, enabled when this option is selected, is used to specify a restoration folder for each local partition:
Column
Description
ServerDisplays the name of the Analysis Services instance that manages the remote partition.
Data SourceDisplays the name of the data source in the backup file that represents the database that contains the remote partition.
Backup FileType the full path and file name of the remote backup file to use, or click the ellipsis button (...) to display the Locate Database Files dialog box and select the path and file name of the remote backup file to use. For more information about the Locate Database Files dialog box, see Locate Database Files Dialog Box (SSAS).
**...**Click to display the Remote Partitions - Advanced Settings dialog box and modify advanced options, such as the connection string for the data source, for restoring the remote partition. For more information about the Remote Partitions - Advanced Settings dialog box, see Remote Partitions - Advanced Settings Dialog Box (SSAS).
See Also
Reference
Restore Database Dialog Box (SSAS)
General (Restore Database Dialog Box) (SSAS)
Other Resources
Backing Up and Restoring an Analysis Services Database