:::: MENU ::::

Configure SQL server password protected backups creation and cleanup

  • Apr 28 / 2010
  • 0
Changing passwords for logins used with SQL Server maintenance plans
Backup and Restore, dbDigger, Encryption, Publications of Atif Shehzad on MSSQLTips.com, Security and Permissions

Configure SQL server password protected backups creation and cleanup

Securing the backup and data files is more important than to establish optimal rights and privileges for database users. SQL Server backup file contains data and log files and it can easily be restored once in hand. It is critical to device a mechanism where backup file should be safe at disk and also another layer of protection is required in backup file itself.
Several tools can be found for backup file encryption, but i have discussed an SQL Server facility to create password protected backup files. It may be used with SQL Server 2000/2005/2008. You can read full article on this topic here.
There are two considerations in this regard

  • The applied password encryption on backup file would not be as reliable as in strongly encrypted files
  • This feature may be removed in future versions of SQL Server, so use it till SQL Server 2008 only
Consult us to explore the Databases. Contact us