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!
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Amit ChoudharyPosted Mar 19, 2011, 8:05 AM
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.
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.