Encrypting datafile and backups

Hi
I read good article on EFS
http://www.sqlservercentral.com/colu...enting_efs.asp
How do you do encryption of backups
I found that the backup made from a encrypted data if recovered are not
encrypted as it is OS encrytion and not database.
Also another interesting question on same line:
If the domain account used to start the sqlserver and encryption is deleted
and recreated with the same login/password will that user be able to decrypt
the files.
Mangesh
Also if we can recover the encrypted file
Mangesh Deshpande wrote:
> Hi
> I read good article on EFS
> http://www.sqlservercentral.com/colu...enting_efs.asp
> How do you do encryption of backups
> I found that the backup made from a encrypted data if recovered are
> not encrypted as it is OS encrytion and not database.
> Also another interesting question on same line:
> If the domain account used to start the sqlserver and encryption is
> deleted and recreated with the same login/password will that user be
> able to decrypt the files.
> Mangesh
> Also if we can recover the encrypted file
You can use a tool like LiteSpeed to encrypt your backups (url below).
David Gugick
Imceda Software
www.imceda.com
|||Hi
EFS is based on Certificates. You loose the Certificate, you loose access to
your data. If you re-set a user's pasword, his certificates become invalid.
Regards
Mike
"Mangesh Deshpande" wrote:

> Hi
> I read good article on EFS
> http://www.sqlservercentral.com/colu...enting_efs.asp
> How do you do encryption of backups
> I found that the backup made from a encrypted data if recovered are not
> encrypted as it is OS encrytion and not database.
> Also another interesting question on same line:
> If the domain account used to start the sqlserver and encryption is deleted
> and recreated with the same login/password will that user be able to decrypt
> the files.
> Mangesh
> Also if we can recover the encrypted file
sql

Encrypting datafile and backups

Hi
I read good article on EFS
http://www.sqlservercentral.com/col...menting_efs.asp
How do you do encryption of backups
I found that the backup made from a encrypted data if recovered are not
encrypted as it is OS encrytion and not database.
Also another interesting question on same line:
If the domain account used to start the sqlserver and encryption is deleted
and recreated with the same login/password will that user be able to decrypt
the files.
Mangesh
Also if we can recover the encrypted fileMangesh Deshpande wrote:
> Hi
> I read good article on EFS
> http://www.sqlservercentral.com/col...menting_efs.asp
> How do you do encryption of backups
> I found that the backup made from a encrypted data if recovered are
> not encrypted as it is OS encrytion and not database.
> Also another interesting question on same line:
> If the domain account used to start the sqlserver and encryption is
> deleted and recreated with the same login/password will that user be
> able to decrypt the files.
> Mangesh
> Also if we can recover the encrypted file
You can use a tool like LiteSpeed to encrypt your backups (url below).
David Gugick
Imceda Software
www.imceda.com|||Hi
EFS is based on Certificates. You loose the Certificate, you loose access to
your data. If you re-set a user's pasword, his certificates become invalid.
Regards
Mike
"Mangesh Deshpande" wrote:

> Hi
> I read good article on EFS
> http://www.sqlservercentral.com/col...menting_efs.asp
> How do you do encryption of backups
> I found that the backup made from a encrypted data if recovered are not
> encrypted as it is OS encrytion and not database.
> Also another interesting question on same line:
> If the domain account used to start the sqlserver and encryption is delete
d
> and recreated with the same login/password will that user be able to decry
pt
> the files.
> Mangesh
> Also if we can recover the encrypted file

Encrypting datafile and backups

Hi
I read good article on EFS
http://www.sqlservercentral.com/columnists/bkelley/implementing_efs.asp
How do you do encryption of backups
I found that the backup made from a encrypted data if recovered are not
encrypted as it is OS encrytion and not database.
Also another interesting question on same line:
If the domain account used to start the sqlserver and encryption is deleted
and recreated with the same login/password will that user be able to decrypt
the files.
Mangesh
Also if we can recover the encrypted fileMangesh Deshpande wrote:
> Hi
> I read good article on EFS
> http://www.sqlservercentral.com/columnists/bkelley/implementing_efs.asp
> How do you do encryption of backups
> I found that the backup made from a encrypted data if recovered are
> not encrypted as it is OS encrytion and not database.
> Also another interesting question on same line:
> If the domain account used to start the sqlserver and encryption is
> deleted and recreated with the same login/password will that user be
> able to decrypt the files.
> Mangesh
> Also if we can recover the encrypted file
You can use a tool like LiteSpeed to encrypt your backups (url below).
--
David Gugick
Imceda Software
www.imceda.com|||Hi
EFS is based on Certificates. You loose the Certificate, you loose access to
your data. If you re-set a user's pasword, his certificates become invalid.
Regards
Mike
"Mangesh Deshpande" wrote:
> Hi
> I read good article on EFS
> http://www.sqlservercentral.com/columnists/bkelley/implementing_efs.asp
> How do you do encryption of backups
> I found that the backup made from a encrypted data if recovered are not
> encrypted as it is OS encrytion and not database.
> Also another interesting question on same line:
> If the domain account used to start the sqlserver and encryption is deleted
> and recreated with the same login/password will that user be able to decrypt
> the files.
> Mangesh
> Also if we can recover the encrypted file

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
>

encrypting backup in sql2000

Hi
Does anyone know what is the best way to encrypt the backups in sql server
2000.
I know sqllite software but are there any freeware or utilities that
can encrypt the backups.
Tks
Mangesh
there could be others as well but the one I found out randomly is
Mizo - CD Librarian License: Freeware
You can find it:
http://www.dirfile.com/freeware/stor...-migration.htm
Regards,

encrypting backup in sql2000

Hi
Does anyone know what is the best way to encrypt the backups in sql server
2000.
I know sqllite software but are there any freeware or utilities that
can encrypt the backups.
Tks
Mangeshthere could be others as well but the one I found out randomly is
Mizo - CD Librarian License: Freeware
You can find it:
http://www.dirfile.com/freeware/sto...e-migration.htm
Regards,sql

encrypting backup in sql2000

Hi
Does anyone know what is the best way to encrypt the backups in sql server
2000.
I know sqllite software but are there any freeware or utilities that
can encrypt the backups.
Tks
Mangeshthere could be others as well but the one I found out randomly is
Mizo - CD Librarian License: Freeware
You can find it:
http://www.dirfile.com/freeware/stored-procedure-migration.htm
Regards,