Ask the Expert

Can I encrypt and restore a database backup in SQL Server 2005?

In my project, there is a request to provide the user with an encrypted database. How can I use EFS (Encrypting File System) to encrypt, decrypt and restore the database backup file in SQL Server 2005?

    Requires Free Membership to View

SQL Server does not provide encryption for backups. You could, however, use third party products such as SQL Backup from Red Gate or SQL LiteSpeed from Quest to get this functionality, as well as many other useful features that these programs provide.

This was first published in October 2008

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: