如何配置Ola Hallengren加密备份脚本

Question

如何向ola.hallengren备份脚本添加加密。

总之，我想做到这一点。

BACKUP DATABASE [MyTestDB]  
TO DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL13.MSSQLSERVER\MSSQL\Backup\MyTestDB.bak'  
WITH  
  COMPRESSION,  
  ENCRYPTION   
   (  
   ALGORITHM = AES_256,  
   SERVER CERTIFICATE = MyTestDBBackupEncryptCert  
   ),  
  STATS = 10  
Go

Answer 1

在Ola Hallengren备份脚本的文档中，他解释了这些参数：

• @Encrypt Y/N意味着加密备份，N是默认的
• @EncryptionAlgorithm -听起来像是在寻找AES_256，这是他支持的一个有效选项
• @ServerCertificate -因此您可以指定要使用的证书

在页面底部，示例中有一个用压缩、加密和服务器证书备份所有用户数据库的示例：

EXECUTE dbo.DatabaseBackup @Databases = 'USER_DATABASES',
@Directory = 'C:\Backup',
@BackupType = 'FULL',
@Compress = 'Y',
@Encrypt = 'Y',
@EncryptionAlgorithm = 'AES_256',
@ServerCertificate = 'MyCertificate'

因此，根据我的广泛研究和三十秒的阅读，它将是：

EXECUTE dbo.DatabaseBackup @Databases = 'MyTestDB',
@Directory = 'C:\Program Files\Microsoft SQL Server\MSSQL13.MSSQLSERVER\MSSQL\Backup\',
@BackupType = 'FULL',
@Compress = 'Y',
@Encrypt = 'Y',
@EncryptionAlgorithm = 'AES_256',
@ServerCertificate = 'MyTestDBBackupEncryptCert'