Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All
Expand Minimize

Location Element (XMLA)

Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).

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 length


Default value



0-n: Optional element that can occur more than once.

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).

Community Additions

© 2015 Microsoft