Discussions specific to the VMware vSphere hypervisor
Post Reply
tom11011
Expert
Posts: 142
Liked: 2 times
Joined: Dec 01, 2010 8:40 pm
Full Name: Tom
Contact:

Backing up MSSQL with TDE

Post by tom11011 » Jan 08, 2019 9:12 pm

Hi Group,

If an organization wants to change their SQL server to enable TDE encryption, how does that effect Veeam backups and restores of the databases?

Currently, the organization backs up two different ways.

1.) They do a typical veeam backup of the entire server on a daily basis utilizing reverse incremental
2.) They do a database dump to a flat .BAK file each night to another server

Occasionally, a restore of a database flat file is asked for so it can be imported to the original or possibly another sql server.

Thanks for your insights.

Mike Resseler
Product Manager
Posts: 5740
Liked: 612 times
Joined: Feb 08, 2013 3:08 pm
Full Name: Mike Resseler
Location: Belgium
Contact:

Re: Backing up MSSQL with TDE

Post by Mike Resseler » Jan 09, 2019 9:34 am

Hey Tom,
They can still continue to do so. There are some considerations/ requirements you need to keep in mind when using TDE encryption. They are described in this article: https://www.veeam.com/kb2006

Hope it helps
Mike

tom11011
Expert
Posts: 142
Liked: 2 times
Joined: Dec 01, 2010 8:40 pm
Full Name: Tom
Contact:

Re: Backing up MSSQL with TDE

Post by tom11011 » Jan 09, 2019 10:11 pm

Thanks for the info.

Post Reply

Who is online

Users browsing this forum: No registered users and 12 guests