Backup Encryption and Encrypted Backup Operation Performance in SQL Server

Abstract

Database security features are important ceses to be focused on database system development. However, using security features can affect the system's performance. Encryption database backup is a kind of security algorithm option, that includes keys and certificates. It is essential for additional layer of security. This study aims to observe how Transparent Data Encryption (TDE) feature, as a solution tool for data security on Microsoft SQL Server, will impact the database performance. In this study, there will be an overview of database backup encryption and encrypted backup operation through backup testing in SQL Server. Hence, the research will be conducted on backup testing for monitoring database system's performance when implementing TDE solution. The study will contribute to the literature with using backup encryption algorithms in SQL Server in terms of efficiency and benchmarking of encrypted backup operation performance with TDE by finding how significant performance change is happening.