CODEWITHSUNDEEP
sql-serverencryptionsql-server-2012
user1144852
user1144852

Reputation: 265

Backup database with encryption

I am using SQL Server 2012. I am trying the query below for DB backup with encryption.

BACKUP DATABASE TestDB
TO DISK = 'C:\DEV\TestDB.bak' WITH 
DIFFERENTIAL,  ENCRYPTION (ALGORITHM = AES_256, SERVER CERTIFICATE = MyBackupCert)

But, it throws errors saying

ENCRYPTION is not a recognized BACKUP option

How to format a query correclty to enable the backup with encryption?

THanks

Upvotes: 0

Views: 2278

Answers (1)

Blorgbeard
Blorgbeard

Reputation: 103467

Unfortunately, you need to upgrade to SQL Server 2014:

Starting in SQL Server 2014, SQL Server has the ability to encrypt the data while creating a backup.

Alternatively, you could enable Transparent Database Encryption, which would encrypt the entire database, and so the backups would be encrypted too.

Or look for a third-party tool.

Upvotes: 2

Related Questions