Database Administration sql 2014

Published on March 23rd, 2015 | by Warner Chaves


Video: SQL Server Native Backup Encryption

In this demo we’re going to show the new SQL Server 2014 capability to do native encrypted backups.

Before the release of SQL Server 2014, encrypted backups were only available in two ways:

a) 3rd party backup tools that came with this functionality.

b) The Enterprise-only transparent database encryption feature.

With SQL Server 2014, now both Standard and Enterprise edition can do encrypted backups natively, no 3rd party tool required, no need to activate TDE either.

Restoring an encrypted backup is a bit more complicated so make sure you understand how the process works, the steps to take and document and protect all the different pieces of information. We’ll go over that in the video, you don’t want to be the DBA that locked himself out of his data!

Check it out!

Tags: , , , , , ,

About the Author

SQL Server Certified Master and MVP. DBA for MS technologies for over 10 years.

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Back to Top ↑
  • Sign Up For Our Newsletter

    Stay up to date on the latest from SQL Server products and Features.

    Sign Up Now

    Sign up for mailing list and receive new posts directly to your inbox.

    We promise never to share or sell any of your personal information.

  • Recent Posts

  • Categories

  • Archives

  • Tags

  • Topics

  • Subscribe to our RSS Feed A SQL Server Web Blog
    Canada, Ontario, Ottawa.

    The Authors