SQL Server Performance

Ok to log ship database w/encrypted columns?

Discussion in 'SQL Server Log Shipping' started by mhavens, Mar 31, 2006.

  1. mhavens New Member

    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
    mhavens, Mar 31, 2006
    #2

  2. satya Moderator

    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.
    satya, Apr 3, 2006
    #2

Share This Page