Hi, i have done the full backup and would like to know how to protect the backup to avoid any one to restore it. Previously i am using WinZip / 7 Zip to compress the Backup file and add in the password for UnCompress, can i do the same in SQL Server 2008 without using the WinZip / 7 zip ? from http://msdn.microsoft.com/en-us/library/ms190964.aspx SQL Server supports password protection for backup media and backup sets. Important The protection provided by this password is weak. It is intended to prevent an incorrect restore using SQL Server tools by authorized or unauthorized users. It does not prevent the reading of the backup data by another method or the replacement of the password. This feature will be removed in the next version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature. thanks.