Database Column encryption

Hi is anyone out there using any third party tools to do
column level encryption.
If so, what tool are you using. And what pitfalls have
you encountered while using them.
Thanks in advance.
JohnJohn,
We use wiCrypt from www.whamware.com. No pitfalls to report.
Tom
"John Oberkehr" wrote:

quote:

---

> Hi is anyone out there using any third party tools to do
> column level encryption.
> If so, what tool are you using. And what pitfalls have
> you encountered while using them.
> Thanks in advance.
> John

---

|||John, you do also have the option of column-level security and views (leave
out the column). I know that's not exactly what you asked though.
Eric
"John Oberkehr" <anonymous@.discussions.microsoft.com> wrote in message
news:093001c3b9ce$2c47cb50$a001280a@.phx.gbl...

quote:

---

> Hi is anyone out there using any third party tools to do
> column level encryption.
> If so, what tool are you using. And what pitfalls have
> you encountered while using them.
> Thanks in advance.
> John

---

|||We use XP_CRYPT www.activecrypt.comsql

database backup with encryption

Hi,

I want to backup my database at regular intervals and encrypt it. Also I want to verify the back up. How do I do it?

I want the back ups to run every fortnight.

Thanks.

For encrypting backups, you have a few different options. Some would include:

Backup or move the backup to an encrypted folder.

Write your own file encryption routine.

Use a third party backup utility that will backup and encrypt. Tools like

Red Gate's SQL Backup

http://www.red-gate.com/products/SQL_Backup/index.htm

or

Quest's LiteSpeed

http://www.quest.com/litespeed-for-sql-server/

In terms of verifying, that depends on what you mean by verify. You can use the restore verifyonly option on backups. That will tell you if the backup file is complete and readable by SQL Server. If you need verification beyond that, you need to test this by restoring the backup to another server (or another database name if using the same server)

-Sue

data type for 32-bit

I am going to generate 32-bit encryption key with combination of any
number of characters. what data type and its size should I use for
that on MS SQL 2005? will it be nvarchar(max) or nvarchar(4000)
appropriate to use? thanks!You can use BINARY(4) if the key is always 32-bit. If it will vary then
maybe VARBINARY(4) will be better.

HTH,

Plamen Ratchev
http://www.SQLStudio.com