Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Password Element
Collapse the table of content
Expand the table of content

Password Element (XMLA)

 

Applies To: SQL Server 2016 Preview

Determines the password to be used by the parent Backup or Restore command for encrypting or decrypting a backup file.


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

Characteristic

Description

Data type and length

String

Default value

None

Cardinality

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

Relationship

Element

Parent elements

Backup, Restore

Child elements

None

For Backup commands, if the Password element is not included or contains an empty string, the backup file is not encrypted.

For Restore commands, if the Password element is not included or contains an empty string while attempting to restore an encrypted backup file, an error occurs.

If Location elements are included in either a Backup or a Restore command, the same Password element is used for both backup and remote backup files. For more information about remote backup files, see Backing Up, Restoring, and Synchronizing Databases (XMLA).

Community Additions

ADD
Show:
© 2015 Microsoft