SQL Server Performance Forum – Threads Archive
logshipping in encripted form over the network
HI DBAs,my client want to setup logshipping say between servers at austraila and newzeland.
He wants the transfer of information over network in encrypted form.Question is… Is is possible and avisable
if so how can i do the same. Thanks
thiru
THIRUVENGADAM
It is possible with third party tools such ashttp://www.red-gate.com/sql/more/log_shipping_using_sqlbackup.htm orhttp://www.red-gate.com/sql/sql_backup.htm fyi. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
I don’t think you can do this with basic MS Log Shipping. With a customized log shipping, many many things are possibly, for example:<br /><br /><pre id="code"><font face="courier" size="2" id="code"><br />AustraliaNew Zealand<br /><br />MSDB <br /> ^<br /> |<br />select list of backups needed<br />Use list of backups required to created a<br />passworded, compressed zip file<br /> |<br /> /<br />backups.zip<br /><br />invoke a route on the "australia server" to<br />encrypt the backups.zip file<br /> |<br /> /<br />backups.zip.enc—————————————->Copy fie to NZ<br />Un-Encrypt File<br />Un-zip file<br />restore log backups<br />LogShip<————————————————Update LogShipping controller to inforn<br />success and update last useed backup file<br /></font id="code"></pre id="code"><br /><br />And of course, you can look into the network this is being done over (VPN) etc. I remember reading about having Network traffic encrypted as well (somewhere) – I really don’t know much about networking [<img src=’/community/emoticons/emotion-6.gif’ alt=’
‘ />]<br /><br />Needless to say, the above will take a bit of hard work to implement, and the time will be quite a bit slower than normal…<br /><br />Panic, Chaos, Disorder … my work here is done –unknown
Given my post above, I clearly don’t have the budget to get nice tools. Nice pointer Satya – I’ve not even seen that before! Panic, Chaos, Disorder … my work here is done –unknown
I agree with basic LS it is not possible and unless you should have VPN in order to perform file copy process. Link forhttp://www.windowsecurity.com/articles/Secure_Architecture_SQL_Web_Server.html more information. The only obvious way I can think of is to have a connection to the SQL Server using an encrypted VPN connection, then connect to SQL Server using the server’s VPN adapter IP address. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
]]>