Encrypting Backups

Is there any way to encrypt a backup written to a tape drive?
I know its possible to do when backing up to disk (using an encrypted file
system), but don't see how to achieve the same with tape.
We want to take our backups off-site, and though it would be prudent to
encrypt the data in casae it was lost, stolen, etc.
Thanks,
LenYou might want to look at some 3rd party apps such as SQLLiteSpeed. They
can compress and encrypt the backups.
Andrew J. Kelly SQL MVP
"Len Binns" <binns@.buffalo.nospam.edu> wrote in message
news:OtDqtzEuEHA.1472@.TK2MSFTNGP10.phx.gbl...
> Is there any way to encrypt a backup written to a tape drive?
> I know its possible to do when backing up to disk (using an encrypted file
> system), but don't see how to achieve the same with tape.
> We want to take our backups off-site, and though it would be prudent to
> encrypt the data in casae it was lost, stolen, etc.
> Thanks,
> Len
>|||BTW,
We're using SQL 2000 on Windows Server 2003, Enterprise Edition.
"Len Binns" <binns@.buffalo.nospam.edu> wrote in message
news:OtDqtzEuEHA.1472@.TK2MSFTNGP10.phx.gbl...
> Is there any way to encrypt a backup written to a tape drive?
> I know its possible to do when backing up to disk (using an encrypted file
> system), but don't see how to achieve the same with tape.
> We want to take our backups off-site, and though it would be prudent to
> encrypt the data in casae it was lost, stolen, etc.
> Thanks,
> Len
>|||We were hoping to stay away from 3rd party apps (just one more thing to
break), but we may have to if there is no other solution.
Is there no solution native to SQL Server 2000 and/or Windows Server 2003?
Thanks,
Len
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:%236wuA5EuEHA.4040@.tk2msftngp13.phx.gbl...
> You might want to look at some 3rd party apps such as SQLLiteSpeed. They
> can compress and encrypt the backups.
> --
> Andrew J. Kelly SQL MVP
>
> "Len Binns" <binns@.buffalo.nospam.edu> wrote in message
> news:OtDqtzEuEHA.1472@.TK2MSFTNGP10.phx.gbl...
file[vbcol=seagreen]
>|||There are no native solutions that I know of for SQL Server. SQL LiteSpeed
is pretty seamless and will enhance your backup and restore capabilities
tremendously. They will be faster, take up less room and uses RC4
encryption. I know it sounds like I am an Imceda salesman but this product
does what it claims and what you are asking for.
Andrew J. Kelly SQL MVP
"Len Binns" <binns@.buffalo.nospam.edu> wrote in message
news:%23oW4FPFuEHA.3320@.TK2MSFTNGP15.phx.gbl...
> We were hoping to stay away from 3rd party apps (just one more thing to
> break), but we may have to if there is no other solution.
> Is there no solution native to SQL Server 2000 and/or Windows Server 2003?
> Thanks,
> Len
> "Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
> news:%236wuA5EuEHA.4040@.tk2msftngp13.phx.gbl...
> file
>