However, Backup Encryption is still not avaliable on SQL Server Express, SQL Server Web, and versions before SQL Server 2014. Therefore, if you are using SQL Server Express, Web, or you want to perform backup encryption in SQL Server 2012, 2008, etc, I suggest you choose the professional backup software which supports all versions. Luckily since SQL Server 2014, the new Backup Encryption option allows us to encrypt the backup while creating, only after we specified an encryption algorithm and an encryptor to secure the encryption key. ![]() SQL Server Versions Backup Encyption Supported?īefore SQL Server 2014, Transparent Data Encryption (TDE) was commonly used to encrypt data at rest, however, it will significantly reduce query performance and increase CPU consumption. You want to restrict access to only those who have authorization.You are going to store your database backups offsite, or on the cloud.You have sensitive data in your database.I strongly suggest you to perform SQL Server Backup Encryption under these circumstances: Therefore, in order not to leak the data, it’s almost a necessity to perform SQL Server Backup Encryption. ![]() We certainly don't want someone to view our database at will without authorization, simply by restoring the backups to their own hardware, especially when we have sensitive data stored in there. When is it Necessary to Perform SQL Server Backup Encryption?Īs database administrators, securing our data is one of our most important tasks.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |