Chapter 9

Database Backup Security

Information in this chapter:

• Overwriting Backups

• Media Set and Backup Set Passwords

• Backup Encryption

• Transparent Data Encryption

• Compression and Encryption

• Offsite Backups

• Summary

All too often people spend all their time securing the database while it is active within the database engine, without providing protection for the database backups. Not securing the database backups provides an easy way for a data thief to get access to all the information stored within the database. This is because the database backups are by definition the least secure portion of the database. They are so insecure because they actually leave the building on a regular basis. This is because the database backups are ...

Get Securing SQL Server, 2nd Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.