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