How to Encrypt a Backup File

Hello, I would like to password-protect or encrypt the .bak file for 3
selected databases on a MS SQL 2000 server. The DBs are all set for Full
recovery mode and the nighly backups run OK now using a DB Maintenance Plan.
How can I encrypt only the backup files without encrypting either the DB or
the server? Thanks, PanchoPancho,
You can use the PASSWORD argument of the BACKUP statment. For encryption of
the backup file, you can use one of many available file encryption
utilities.
HTH
Jerry
PS - Litespeed will encrypt and compress your backups if needed.
"Pancho" <Pancho@.discussions.microsoft.com> wrote in message
news:D6078784-DF5B-4B79-9C76-A26723EB0930@.microsoft.com...
> Hello, I would like to password-protect or encrypt the .bak file for 3
> selected databases on a MS SQL 2000 server. The DBs are all set for Full
> recovery mode and the nighly backups run OK now using a DB Maintenance
> Plan.
> How can I encrypt only the backup files without encrypting either the DB
> or
> the server? Thanks, Pancho|||Note that the password features on backups are now obsolete. According to
BOL (SQL Server 2005) the "protection is weak" and intended to "prevent an
incorrect restore". "It does not prevent the reading of the backup data".
Ben Nevarez, MCDBA, OCP
Database Administrator
"Jerry Spivey" wrote:
> Pancho,
> You can use the PASSWORD argument of the BACKUP statment. For encryption of
> the backup file, you can use one of many available file encryption
> utilities.
> HTH
> Jerry
> PS - Litespeed will encrypt and compress your backups if needed.
> "Pancho" <Pancho@.discussions.microsoft.com> wrote in message
> news:D6078784-DF5B-4B79-9C76-A26723EB0930@.microsoft.com...
> > Hello, I would like to password-protect or encrypt the .bak file for 3
> > selected databases on a MS SQL 2000 server. The DBs are all set for Full
> > recovery mode and the nighly backups run OK now using a DB Maintenance
> > Plan.
> > How can I encrypt only the backup files without encrypting either the DB
> > or
> > the server? Thanks, Pancho
>
>|||place backup to encrypted folder
--
Aleksandar Grbic
MCDBA
"Pancho" wrote:
> Hello, I would like to password-protect or encrypt the .bak file for 3
> selected databases on a MS SQL 2000 server. The DBs are all set for Full
> recovery mode and the nighly backups run OK now using a DB Maintenance Plan.
> How can I encrypt only the backup files without encrypting either the DB or
> the server? Thanks, Pancho|||Thank you Jerry, Ben and Aleksandar. These were all helpful ideas and I
posted a helpful rating to each.
Best Regards, Pancho
"Aleksandar Grbic" wrote:
> place backup to encrypted folder
> --
> Aleksandar Grbic
> MCDBA
>
> "Pancho" wrote:
> > Hello, I would like to password-protect or encrypt the .bak file for 3
> > selected databases on a MS SQL 2000 server. The DBs are all set for Full
> > recovery mode and the nighly backups run OK now using a DB Maintenance Plan.
> > How can I encrypt only the backup files without encrypting either the DB or
> > the server? Thanks, Pancho