I'm faced with the need to do encry

[ShackDaddy]

I'm faced with the need to do encryption on our SQL data. What sorts of options are available for the following scenarios?

1) Encrypting the database file (options besides Win2k EFS).

2) Encrypting the datastream to and from a COM server. (less critical)

3) Encrypting the data when it is backed up to tape. (We currently use Veritas BackupExec)

I'm being told that encryption on all these three levels is 'standard' among 'serious' shops. If this is true, how is it being accomplished?

TIA

ShackDaddy

 

[Guest_imported]

from what I have heard it isnt all that standard. But if you want to you can use/look at the crypto-API (look around microsofts web site.)
If you do encryption either on the front end or with extended stored procedures, the data will be encrypted both on the disk and on backups. If you do it on the front end it will be encrypted in transit. Alittle hard though.