Restore Element (XMLA)

Restore Element

Community Content

In this section

Statistics Annotations (0)

Click here to expand

Collapse All

Language Filter

SQL Server 2005 Books Online (November 2008)

Restore Element (XMLA)

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

Syntax

xml

<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

Remarks

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

Reference

Concepts

Help and Information