how to keep password for sql db like ms access

Question

I want to secure sql 2005 db so that no body could open it. If anyone get backup copy of it while restoring it should ask for authenication(password). Help me!

Amit Choudhary · Answer

hi friend Here is the workaround for you requirement: Media set password The media set password is saved when the media header is written; it cannot be changed. If a password was provided when the media set was formatted that password must be supplied to create a backup set on that media set. Additionally that media password must also be supplied to perform any restore operation from the media set. Note You can only use the media for SQL Server backup and restore operations. To specify a media set password use the MEDIAPASSWORD option in the BACKUP or RESTORE statement. Source article: http://msdn.microsoft.com/en-us/library/ms190964.aspx Hope this was helpful. Don't forget to mark as answer. Thanks.