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