QuestionQ73

VerifiedPlan and configure a high availability and disaster recovery (HA/DR) environment

You have SQL Server 2019 on an Azure virtual machine that contains an SSISDB database.

A recent failure causes the master database to be lost. You discover that all Microsoft SQL Server Integration Services (SSIS) packages fail to run on the virtual machine.

Which four actions should you perform, in sequence, to resolve the issue?

Drag & Drop
Explanation

SSISDB requires CLR integration and its database TRUSTWORTHY setting. After the master database is lost, the replacement SQL Server service master key cannot decrypt SSISDB’s existing database master key. Opening that key with its password and then encrypting it with the current service master key restores automatic decryption for SSISDB. TDE and Azure Key Vault certificates do not restore this key relationship.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!