1

Yes, SQL Server 2016 and 2019 Web Edition supports encryption on AWS. If you're running SQL Server 2012–2019 Enterprise Edition or 2019 Standard Edition, you can use Transparent Data Encryption (TDE) to achieve encryption at rest. You can set up encryption at rest by using AWS Key Management Service (AWS KMS) encryption keys. For more information, see ...


1

For completeness, the "RsFx Driver" is a filesystem filter driver that implements Microsoft WinFS to enable Microsoft SQL FILESTREAM functionality (transactional storage of binary data in external files). The driver has the vague description "allows Win32 user-mode applications/services to own and manage Win32 namespaces of the UNC format"...


1

Can e.g. the snapshots be configured to be "copy-only" so that they don't mess up the normal backups? Yes, Windows Server Backup allows to choose between these two options: VSS full backup VSS copy backup Choosing "VSS copy backup" should leave your SQL Server backups intact. This tech community article explains the setting. If you're ...


1

From Microsoft site: If the Update Cache folder or some patches are removed from this folder, you can no longer uninstall an update to your SQL Server instance and then revert to an earlier update build. In that situation, Add/Remove Programs entries point to non-existing binaries, and therefore the uninstall process does not work. Therefore, Microsoft ...


Only top voted, non community-wiki answers of a minimum length are eligible