How to Secure the Database when Restore the Database

Question

Post reply

How to Secure the Database when Restore the Database

tamil.selvanmca

Ten Centuries

Points: 1367
More actions
June 23, 2012 at 8:48 am

#258449

I Create the Job for automatic Database Backup and I want to secure my database for others to restore(Misuse the database).
Database administrator Only restore the backup. Other could not restore my database.
What are the steps I want to do?

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

M&M SSC-Insane Points: 21700 More actions · Answer 1

You could check this link on TDE for a quick understanding TDE[/url]

M&M

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 2

Make sure only the DBA has the required rights to restore a DB.

Or do you mean you want to secure the backup file so it can't be restored elsewhere?

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

tamil.selvanmca Ten Centuries Points: 1367 More actions · Answer 3

I want to secure the backup file so it can't be restored elsewhere by any One.

I want to protect my backup file.

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 4

Then you need to enable TDE (Transparent Database Encryption) on the database itself, or use a 3rd party tool that allows for encrypting backups.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Perry Whittle SSC Guru Points: 234013 More actions · Answer 5

tamil.selvanmca (6/23/2012)
I want to secure the backup file so it can't be restored elsewhere by any One.
I want to protect my backup file.

Ensure you understand the effects and requirements of TDE before just enabling it.

A 3rd party backup solution may be a better approach.

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs" 😉

vikingDBA SSCertifiable Points: 5356 More actions · Answer 6

Also, make sure the disk directories that hold the backups (on the database server where the backups are taken) are secured, and no one else has access to them that isn't supposed to.