Partilhar via


AllowOverwrite Element (XMLA)

Determines whether the parent Backup or Restore command attempts to overwrite the target file or database.

Syntax

<Backup> <!-- or Restore -->
   ...
   <AllowOverwrite>...</AllowOverwrite>
   ...
</Backup>

Element Characteristics

Characteristic Description

Data type and length

Boolean

Default value

False

Cardinality

0-1: Optional element that can occur once and only once.

Element Relationships

Relationship Element

Parent elements

Backup, Restore

Child elements

None

Remarks

For Backup commands, the AllowOverwrite element determines whether the command can overwrite the backup file specified in the File element.

For Restore elements, the AllowOverwrite element determines whether the command can overwrite the Microsoft SQL Server Analysis Services database specified in the DatabaseName element.

See Also

Reference

DatabaseName Element (XMLA)
File Element (XMLA)

Concepts

Properties (XMLA)

Help and Information

Getting SQL Server 2005 Assistance