Re: Manual Logshipping - How to encrypt the transaction log backup fil

From: Andrew J. Kelly (sqlmvpnooospam_at_shadhawk.com)
Date: 07/15/05 

Date: Fri, 15 Jul 2005 14:58:55 -0400

Take a look at SQLLiteSpeed from www.imceda.com . It will do log shipping
for you and can encrypt and compress the backup files. It shuld make things
better all around for you. 

-- 
Andrew J. Kelly  SQL MVP
"S Siva Prasad [SIVA]" <SSivaPrasadSIVA@discussions.microsoft.com> wrote in 
message news:5F1EFFBF-6BAD-45BF-B02A-766F7DA880B1@microsoft.com...
> 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

Relevant Pages

  • Manual Logshipping - Using Encrypted DB Transactional Log backup
    ... maintain the standby database "DB2" on Standby Server in Brisbane. ... The reason why I am going for the manual log shipping over the Log ... Since in the SQL Server feature of Log Shipping the transaction log ... Hence transferring of the transaction log file backup ...
    (microsoft.public.sqlserver.setup)
  • Re: SSIS Package - minimize the Log Space
    ... Ekrem Önsoy ... Shrinking your transaction log file does not break your Log Shipping as long as you don't back up your Transaction Log manually or using another job other than Log Shipping' s backup job. ... Log Shipping is in place and every hald an hour I take log backup and that has 100 MB in Size but the only problem is MyDB.ldf file size is 3 GB and MyDB.mdf file size is 25 GB. ...
    (microsoft.public.sqlserver.clients)
  • Re: Why should I use LogShipping and not Replication
    ... Log shipping doesn't "replicate" anything. ... the transaction log will be moved with log shipping. ... You get everything in the database ... Replication uses various techniques to duplicate transactions between ...
    (microsoft.public.sqlserver.replication)
  • Re: SSIS Package - minimize the Log Space
    ... Log Shipping is in place and every hald an hour I take log backup and that ... is there any impace on Log Shipping? ... executing transaction log backups via your Log Shipping configuration. ... I am using SSIS Package that import 1 million of recrods in CHART ...
    (microsoft.public.sqlserver.clients)
  • Re: SSIS Package - minimize the Log Space
    ... Shrinking your transaction log file does not break your Log Shipping as ... How about the transaction log backup intervals and what's the current ...
    (microsoft.public.sqlserver.clients)