always-encrypted-migrate-using-backup-restore.md

title	Backup and restore databases using Always Encrypted | Microsoft Docs
ms.custom
ms.date	10/30/2019
ms.prod	sql
ms.reviewer	vanto
ms.technology	security
ms.topic	conceptual
ms.assetid	29816a41-f105-4414-8be1-070675d62e84
author	jaszymas
ms.author	jaszymas
monikerRange	=azuresqldb-current||>=sql-server-2016||=sqlallproducts-allversions||>=sql-server-linux-2017||=azuresqldb-mi-current

Backup and restore databases using Always Encrypted

[!INCLUDEappliesto-ss-asdb-xxxx-xxx-md]

This article describes how to back up and restore a database containing columns protected with Always Encrypted.

When you back up a database, the resulting backup file contains encrypted stored in encrypted columns and all metadata for Always Encrypted keys.

When you restore a database, all encrypted data and all metadata for Always Encrypted keys are restored.

If you restored the database on a different server or under a different name, you don't need to do anything special to enable the application to query the encrypted data in the target database, as the keys in both databases are the same.

For detailed information about how to back up and restore a database, see:

• Backup Overview (SQL Server)
• Restore a database to a Managed Instance

Next Steps

• Query columns using Always Encrypted with SQL Server Management Studio
• Develop applications using Always Encrypted with secure enclaves

See Also

• Always Encrypted
• Export and import databases using Always Encrypted
• Migrate data to or from columns using Always Encrypted with SQL Server Import and Export Wizard
• Bulk load encrypted data to columns using Always Encrypted