SQL Server Performance

logshipping in encripted form over the network

Discussion in 'SQL Server Log Shipping' started by THIRUVENGADAM, Jul 26, 2005.

  1. THIRUVENGADAM New Member

    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
  2. satya Moderator

  3. SQL_Guess New Member

    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----------------------------------------&gt;Copy fie to NZ<br />Un-Encrypt File<br />Un-zip file<br />restore log backups<br />LogShip&lt;------------------------------------------------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
  4. SQL_Guess New Member

    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
  5. satya Moderator

    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.

Share This Page