Quick question, I am backing up SQL Server Database every night, I want to
encrypt the database backup file?

Is there any way through scheduler I can take the backup as well as encrypt
it.

Thanks

Noor

Your best bet is to use one of the 3rd party backup tools (red-gate, Quest
etc) to do the backup, compress it and encrypt it all in one.

--
Andrew J. Kelly SQL MVP

"Rogers" <naissani (AT) hotmail (DOT) com> wrote

If you are using SQL 2000, you can backup to named pipes and use a
tool that can read from pipe and write the encrypted output to a file.
I used this technique with the Sure Crypt tool
http://www.softpedia.com/get/Securit...ureCrypt.shtml and
these commands:

--Backup database to a pipe
backup database pubs to pipe ='\\.\pipe\pubs_pipe'

--At the command prompt type
sc dsckey.dat e \\.\pipe\PUBS_pipe pubs.bkp.enc

where sc is the ecncryption tool reading from the pipe and writing to
pubs.bkp.enc and dsckey.dat is your key file.

However, since SQL 2005 doesn't support named pipes as backup device,
I wrote a simple tool (zipvdi) that makes all the work in a single
step and compatible with SQL 2k and 2k5
Give ZipVDI a try from http://jcarlossaez.blogspot.com/2007...ql-server.html

Regards