Location Element
Collapse the table of content
Expand the table of content

Location Element (XMLA)


Applies To: SQL Server 2016 Preview

Contains information about a remote server for the parent Backup, Restore, or Synchronize command.

<Backup> <!-- or one of the elements listed below in the Element Relationships table -->  

<File>...</File> <!-- for Backup and Restore only -->  
<DataSourceType>...</DataSourceType> <!-- for Restore and Synchronize only -->  
<ConnectionString>...</ConnectionString> <!-- for Restore and Synchronize only -->  
<Folders>...</Folders> <!-- for Restore and Synchronize only -->  


Data type and lengthNone
Default valueNone
Cardinality0-n: Optional element that can occur more than once.
Parent elementsBackup, Restore, Synchronize
Child elementsSee the table below.
Ancestor or ParentChild Element
BackupDataSourceID, File
RestoreConnectionString, DataSourceID, DataSourceType, File, Folders
SynchronizeConnectionString, DataSourceID, DataSourceType, Folders

For Backup commands, the Location element provides information about creating a remote backup file for a remote instance of Microsoft SQL Server Analysis Services.

For Restore commands, the Location element provides information about identifying and connecting to a remote Analysis Services instance, as well as the remote backup file used to restore remote partitions on that remote instance.

For Synchronize commands, the Location element describes either a data source to be used by the target instance or a remote instance defined on the source instance that must be synchronized with the target instance, depending on the value of the DataSourceType element for the parent Synchronize command.

For more information about backing up and restoring remote instances, see Backing Up and Restoring Objects (XMLA).

BackupRemotePartitions Element (XMLA)
Properties (XMLA)

Community Additions

© 2016 Microsoft