password-element-xmla.md

title	Password Element (XMLA) | Microsoft Docs
ms.custom
ms.date	03/06/2017
ms.prod	sql-server-2016
ms.reviewer
ms.suite
ms.technology	analysis-services docset-sql-devref
ms.tgt_pltfrm
ms.topic	reference
apiname	Password Element
apilocation	http://schemas.microsoft.com/analysisservices/2003/engine
apitype	Schema
applies_to	SQL Server 2016 Preview
f1_keywords	http://schemas.microsoft.com/analysisservices/2003/engine#Password urn:schemas-microsoft-com:xml-analysis#Password microsoft.xml.analysis.password
helpviewer_keywords	Password element
ms.assetid	8a0603bd-f6a1-4b86-84f1-c83d0b03951b
caps.latest.revision	11
author	jeannt
ms.author	jeannt
manager	erikre

Password Element (XMLA)

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

Syntax

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

Element Characteristics

Characteristic	Description
Data type and length	String
Default value	None
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, 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).

See Also

Location Element (XMLA)
Properties (XMLA)