469,890 Members | 2,154 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,890 developers. It's quick & easy.

Log Shipping Transaction Log Question

I am going through a security audit on our servers. We use log shipping
for a standby database. One of the questions in the audit has me
looking for answers.

"Are the transaction logs that are being shipped to the standby
database encrypted?"

I am assuming no. However, I need to know definitively. I have not been
able to find an answer in BOL or in Google. If the logs are not
encrypted, is there an option where I could send them encrypted, if
necessary?

Thanks,
Jennie

Jul 23 '05 #1
2 2006
They're not encrypted - there are a number of 3rd-party products
available which can reconstruct SQL commands from reading transaction
log files. I'm afraid I have no idea whether or not there is a simple
(or even a complex!) way to encrypt/decrypt them, though.

Jul 23 '05 #2
Hi

If you are worried about encryption over the wire, then you need to do it at
network packet level as all your other traffic is sniffable.

SQL will not encrypt the files, and if you are using the built-in Log
shipping, you can't do it.

If you were to roll your own version of log shipping using scripts, you
could use a 3rd party tool the encrypt it.

Regards
--------------------------------
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland

IM: mi**@epprecht.net

MVP Program: http://www.microsoft.com/mvp

Blog: http://www.msmvps.com/epprecht/

"Phil" <ph*********@gmail.com> wrote in message
news:11**********************@z14g2000cwz.googlegr oups.com...
They're not encrypted - there are a number of 3rd-party products
available which can reconstruct SQL commands from reading transaction
log files. I'm afraid I have no idea whether or not there is a simple
(or even a complex!) way to encrypt/decrypt them, though.

Jul 23 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

By using this site, you agree to our Privacy Policy and Terms of Use.