Manual Logshipping - How to encrypt the transaction log backup fil

From: S Siva Prasad [SIVA] (SSivaPrasadSIVA_at_discussions.microsoft.com)
Date: 07/15/05 

Date: Fri, 15 Jul 2005 10:52:09 -0700

The scenario is like that,

  Database "DB1" on the Production Server ( Prod1 ) in Sydney has to
maintain the standby database "DB2" on Standby Server (Prod2) in Brisbane.

  Proposed solution is to setup manual Log Shipping by copying of transaction
log files from the Production server to Standby Server.

   The reason why I am going for the manual log shipping over the Log
Shipping feature available in SQL Sever 2000 to comply with our security
auditing recruitments.

     Since in the SQL Server feature of Log Shipping the transaction log
file is not encrypted. Hence transferring of the transaction log file backup
over the network would lead to security risk.

     The questions is.,

    Since the data are confidential. How to encrypt the transaction log file
while transmitting over the network? 

-- 
Thanks
S SIVAPRASAD