SQL Server 数据库加密标准版与 Web 版本

huangapple go评论84阅读模式
英文:

SQL Server database encryption Standard vs Web editions

问题

数据加密在SQL Server标准版和Web版中可用。

我对Web版有一个问题,SQL Server备份是否加密?

SQL Server 2022的版本和支持功能

在这个Microsoft网站上,对于Web版,"加密备份"显示为否。

我了解到非加密数据库无法有加密备份,但如果数据库已经加密,SQL Server备份是否也会被加密呢?

我还没有测试过这一点,因为我正在为客户请求设置具有静态数据加密的新服务器。

尝试决定是否使用SQL Server标准版或Web版。SQL Server Web版一直在我们基于Web的软件中表现良好,并且比SQL Server标准版更便宜。

有其他想法/建议吗?

英文:

Data encryption is available in SQL Server Standard and Web editions.

The question I have on the web edition, is the SQL Server backup encrypted?

Editions and supported features of SQL Server 2022

On this Microsoft website it states for web edition "Encrypted backup" says no.

I understand that a non encrypted database cannot have an encrypted backup, but if the database was already encrypted wouldn't the SQL Server backup also be encrypted?

I have not tested this because I am setting up new server with database encryption at rest per a customer request.

Trying to decide whether to use SQL Server Standard or Web editions. SQL Server Web edition has always worked well for our web based software and is cheaper than SQL Server Standard edition.

Any additional thoughts/advice?

答案1

得分: 1

如果数据库已经加密,SQL Server备份也会被加密吗?

是的,它会被加密。

Web Edition支持透明数据加密(TDE),TDE数据库的备份始终是加密的。

启用了TDE的数据库的备份文件也会使用数据库加密密钥进行加密。因此,当您还原这些备份时,必须提供用于保护数据库加密密钥的证书。因此,除了备份数据库之外,确保维护服务器证书的备份也是非常重要的。如果证书不再可用,可能会导致数据丢失。

透明数据加密

备份加密功能专门用于创建非加密数据库的加密备份。

英文:

>but if the database was already encrypted wouldn't the SQL Server backup also be encrypted?

Yes it would be encrypted.

Web Edition supports Transparent Data Encryption, and backups of TDE databases are always encrypted.

> Backup files for databases that have TDE enabled are also encrypted
> with the database encryption key. As a result, when you restore these
> backups, the certificate that protects the database encryption key
> must be available. Therefore, in addition to backing up the database,
> make sure to maintain backups of the server certificates. Data loss
> results if the certificates are no longer available.

Transparent Data Encryption

The Backup Encryption feature is specifically to create encrypted backups of non-encrypted databases.

答案2

得分: 0

Web Edition不支持这一功能。

但是,您可以通过直接将备份文件备份到加密卷(使用BitLocker或者甚至内建于NTFS/Windows的加密功能),然后在将备份文件复制到像磁带或云备份环境这样的持久存储之前,使用额外的加密工具来满足备份加密要求。

英文:

Web Edition does not support this.

However, you can easily meet backup encryption obligations separate from anything built into SQL Server by backing up directly to an encrypted volume (using BitLocker or even built into NTFS/Windows in a pinch), and then further using an additional encryption utility as (or before) you copy the backup file(s) to persistent storage like tape or cloud backup environment.

huangapple
  • 本文由 发表于 2023年7月13日 22:52:53
  • 转载请务必保留本文链接:https://go.coder-hub.com/76680780.html
匿名

发表评论

匿名网友

:?: :razz: :sad: :evil: :!: :smile: :oops: :grin: :eek: :shock: :???: :cool: :lol: :mad: :twisted: :roll: :wink: :idea: :arrow: :neutral: :cry: :mrgreen:

确定