Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I want to disallow restore from backup. How can I do this? One Of my friends said to me

"Take a certificate for your database and anyone cant restore from your backup"

I searched about certificate but I didn't find anything. I want to be sure that nobody copy my database from backup or the other ways.

Is there anyway about this problem?

share|improve this question

migrated from Feb 1 '12 at 14:08

This question came from our site for professional and enthusiast programmers.

Could you simply encrypt the backup file? – Mr Moose Feb 1 '12 at 8:29
I serched for encrypting but can someone decrypt the databse? – mehmetkarpuz Feb 1 '12 at 8:40
A backup that can't be restored from doesn't sound like it would be much use... – AakashM Feb 1 '12 at 9:28
Can you add more context? Do you want to make backup files secure? Or prevent actual RESTOREs on the original database servers – gbn Feb 1 '12 at 9:29
I am assuming that access to SQL Server is locked down, so your main concern is the backup files. You could use one of many available encryption tools to encrypt a backup file. You could then decrypt the backup file prior to a restore. Something like comes to mind as a possibility. – Mr Moose Feb 1 '12 at 12:17

Quick answer: You can't.

Physical access to the backup file will allow someone to restore it. The password feature isn't secure and will be removed anyway. See "Security Considerations for Backup and Restore" on MSDN

To prevent someone running RESTORE and destroying a working database, then ensure that only the correct folk have permissions to do this

share|improve this answer
Thank you for your Quick answer.. Are you sure isnt this possible? I dont want anbody copy my database.. I am not sql admin on sql server. So someone can copy my db. Isnt there any solution without SQL Encryption? – mehmetkarpuz Feb 1 '12 at 12:01
you can't stop someone copying it. they may be able to export it without admin or physical access – gbn Feb 1 '12 at 12:04

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.