Partager via


Restore Element (XMLA)

Restores a Microsoft SQL Server 2005 Analysis Services (SSAS) database from a backup file.

Syntaxe

<Command>
   <Restore>
      <DatabaseName>...</DatabaseName
      <File>...</File>
      <Security>...</Security>
      <AllowOverwrite>...</AllowOverwrite>
      <Password>...</Password>
      <Locations>...</Locations>
   </Restore>
</Command>

Element Characteristics

Characteristic Description

Data type and length

None

Default value

None

Cardinality

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

Element Relationships

Relationship Element

Parent elements

Command

Child elements

AllowOverwrite, DatabaseName, File, Locations, Password, Security

Notes

The Restore command restores an Analysis Services database specified in the DatabaseName element from a backup file and optionally restores remote partitions from remote backup files.

Depending on the storage mode used by objects stored in the backup file, the Restore command restores information as listed in the following table.

Storage mode Information

Multidimensional OLAP (MOLAP)

Source data, aggregations, and metadata

Hybrid OLAP (HOLAP)

Aggregations and metadata

Relational OLAP (ROLAP)

Metadata

During a Restore command, an exclusive lock is placed on the Analysis Services database specified in the DatabaseName element and released after the Restore command has completed.

For more information about backing up and restoring databases, see Backing Up, Restoring, and Synchronizing Databases (XMLA).

Voir aussi

Référence

Backup Element (XMLA)
Batch Element (XMLA)
Parallel Element (XMLA)
Synchronize Element (XMLA)

Concepts

Commands (XMLA)

Aide et Informations

Assistance sur SQL Server 2005