November 10, 2016 at 8:09 am
Hi Guys,
I have 2 x Database servers (1 production and 1 DR) running SQL Server 2012 edition on Windows 2012.
We have set-up log shipping from Production to DR.
As a requirement, we need to ensure connections between Production and DR is encrypted.
As u are aware, log shipping involves transferring of txn logs over smb share.
If this is the case, SSL encryption doesn't help as those txn logs are copied over the smb? instead of the port that SQL server used (eg, 1433)?
The only way is to use IPSEC? Or any other suggestion?
I read that windows 2012 actually have smb encryption feature. Is this sufficient to ensure the txn logs copied over are encrypted?
Kindly share if u have any ideas or similar experience.
thanks
November 10, 2016 at 10:03 am
log backups are not encrypted at this version unless TDE in use or using 3rd party backup solution.
SQL 2014 offers encrypted backups
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 10, 2016 at 12:05 pm
Just modify log shipping and zip/encrypt the files and move them yourself. Easy-peasy and I have done this at a number of clients over the years (including one that had over 7400 databases the primary server). 😎
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply