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
>

Empty log file

Hello
Someone said to me that only a complete tape backup will empty the log file. THe log is backed up but the file is not empty
I thought that a complete backup to disk or tape will empty the log file
Do anyone know the answer
Regard
Stefan NäsmanI'm not sure what you mean by "complete backup". A database backup does not
empty the log file, nor does a differential, file or filegroup backup. The
only backup type that actually empties a log file is a transaction log
backup. If you don't want to do transaction log backups (for some strange
reason), then just put the database in simple recovery mode.
--
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Stefan Näsman" <anonymous@.discussions.microsoft.com> wrote in message
news:7F9F50EB-4463-48A8-9150-D6C2FCDFED1E@.microsoft.com...
> Hello!
> Someone said to me that only a complete tape backup will empty the log
file. THe log is backed up but the file is not empty.
> I thought that a complete backup to disk or tape will empty the log file.
> Do anyone know the answer?
> Regards
> Stefan Näsman|||Stefan
Backup Log file removes inactivate portion of log file ( commited
transaction written to the disk)
"Stefan N?sman" <anonymous@.discussions.microsoft.com> wrote in message
news:7F9F50EB-4463-48A8-9150-D6C2FCDFED1E@.microsoft.com...
> Hello!
> Someone said to me that only a complete tape backup will empty the log
file. THe log is backed up but the file is not empty.
> I thought that a complete backup to disk or tape will empty the log file.
> Do anyone know the answer?
> Regards
> Stefan N?sman

Empty log file

Hello!
Someone said to me that only a complete tape backup will empty the log file.
THe log is backed up but the file is not empty.
I thought that a complete backup to disk or tape will empty the log file.
Do anyone know the answer?
Regards
Stefan N?smanI'm not sure what you mean by "complete backup". A database backup does not
empty the log file, nor does a differential, file or filegroup backup. The
only backup type that actually empties a log file is a transaction log
backup. If you don't want to do transaction log backups (for some strange
reason), then just put the database in simple recovery mode.
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=...ublic.sqlserver
"Stefan Nsman" <anonymous@.discussions.microsoft.com> wrote in message
news:7F9F50EB-4463-48A8-9150-D6C2FCDFED1E@.microsoft.com...
> Hello!
> Someone said to me that only a complete tape backup will empty the log
file. THe log is backed up but the file is not empty.
> I thought that a complete backup to disk or tape will empty the log file.
> Do anyone know the answer?
> Regards
> Stefan Nsman|||Stefan
Backup Log file removes inactivate portion of log file ( commited
transaction written to the disk)
"Stefan N?sman" <anonymous@.discussions.microsoft.com> wrote in message
news:7F9F50EB-4463-48A8-9150-D6C2FCDFED1E@.microsoft.com...
> Hello!
> Someone said to me that only a complete tape backup will empty the log
file. THe log is backed up but the file is not empty.
> I thought that a complete backup to disk or tape will empty the log file.
> Do anyone know the answer?
> Regards
> Stefan N?sman