question

samirfar avatar image
samirfar asked

How can you protect your database so that no one can copy and restore it

How can you protect your database so that no one can copy and restore it
securitycopy-databaseprotection
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Grant Fritchey avatar image
Grant Fritchey answered
The first, and most important aspect, is making sure that you have security set up appropriately. That people have the least possible permissions within the system. That should prevent random users from getting access to things that they shouldn't have. You'll also want to make sure specifically that you control who can run backups. As far as backups go, you can use [encryption within the system][1] which will require security to restore the database. You can also look to third party backup tools to help with that. But the most important is ensuring that you have security set up appropriately on the system in the first place. [1]: https://msdn.microsoft.com/en-us/library/bb964742.aspx
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.