For the first time in SQL Server, you can encrypt your backups using the native SQL Server backup tool. In SQL Server 2014, the backup tool supports several encryption algorithms, including AES 128, AES 192, AES 256, and Triple DES. You will need a certificate or an asymmetric key when taking encrypted backups. Obviously, there are a number of benefits to encrypting your SQL Server database backups, including securing the data in the database. This can also be very useful if you are using transparent data encryption (TDE) to protect your database's data files. Encryption is also supported using SQL Server Managed Backup to Microsoft Azure.
Getting Started with SQL Server 2014 Administration
By :
Getting Started with SQL Server 2014 Administration
By:
Overview of this book
Table of Contents (13 chapters)
Getting Started with SQL Server 2014 Administration
Credits
About the Author
About the Reviewers
www.PacktPub.com
Preface
Free Chapter
SQL Server 2014 and Cloud
Backup and Restore Improvements
In-Memory Optimized Tables
Delayed Durability
AlwaysOn Availability Groups
Performance Improvements
Index
Customer Reviews