Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
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 -->
   ...
   <Location>

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

   </Location>
   ...
</Backup>

Characteristic

Description

Data type and length

None

Default value

None

Cardinality

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

ADD
Show:
© 2015 Microsoft