Ok to log ship database w/encrypted columns? | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Ok to log ship database w/encrypted columns?

We are releasing a new web product that utilizes column based encryption (for credit card processing), and the developers want to know if it’s still ok to log ship/db mirror to another server, and have that data still retrievable on the failover server (should we need to do that)? What (if any) are the issues that brings up? Thanks! Mark Havens

Log shipping is concerned with the database transaction log and the technology is to copy the file from primary server to secondary server, then restore the same Tlog to maintain warm standby server. We never had any problem in such scenario. Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
]]>