They need to be implemented not just in the production environment, but within our backup solution as well.Įarlier versions of SQL Server had a limitation on this security feature we had to use third-party solutions to encrypt and compress the backup files. Security best-practices are in place in order to secure the metaphorical soul. What good, then, is it to lock the doors of your own equipment, when the soul has already departed?

If someone gets unauthorized access to the site, they could simply restore a copy of your database from a backup, onto their own hardware. Data security has to be thought of from a different perspective now. The data literally resides on someone else’s infrastructure. While this is less of a challenge in an all-on-premises environment, database backups stored off-site or on the cloud require some more precaution. Apart from keeping the data secure, a database administrator also has to keep the system up and running, and restore the data as needed, in case of a failure, with minimal impact to the business. Terabytes of data, millions of rows the entire business depends on this - a database administrator’s responsibility is as massive as it sounds.

Sql back up master