Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-04-11 : 09:22:26
|
| Mark writes "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" |
|
|
bakerjon
Posting Yak Master
145 Posts |
Posted - 2006-04-11 : 13:31:11
|
| While I haven't done this myself, it would seem that there would be no problem with this. If the data is encrypted when it's stuffed into the database, that's just data to SQL Server. Log Shipping and DB Mirroring work on a transactional basis (though very differently). It will be encrypted on the target server just the same as the source. This should work just fine.That's my $0.02JonHolding it down on the engineering tip, y'all!http://www.sqljunkies.com/weblog/outerjoin |
 |
|
|
|
|
|
Log ship/DB Mirror a DB using column encryption?