Red gate alert for TDE databases restore
bestrongself
Posts: 8 New member
Database AA TDEd on sql server A.
I have TDE encrypted database monitor and alert setup.
I restore Database BB from database AA's TDE encrypted backup. restore encrypted backup .bak file.
When restore stars, I get redgate alert: Non-TDE database BB
when restore completes, I get redgate alert: End Non-TDE database BB.
Looks restore TDE triggers red gate alert.
How to stop/exclude this kind of alert-- alerts starts when restore TDE starts and restore ends when TDE ends? Maybe change alert level or...? Don't want to keep receiving this alert.
Thanks
I have TDE encrypted database monitor and alert setup.
I restore Database BB from database AA's TDE encrypted backup. restore encrypted backup .bak file.
When restore stars, I get redgate alert: Non-TDE database BB
when restore completes, I get redgate alert: End Non-TDE database BB.
Looks restore TDE triggers red gate alert.
How to stop/exclude this kind of alert-- alerts starts when restore TDE starts and restore ends when TDE ends? Maybe change alert level or...? Don't want to keep receiving this alert.
Thanks
Tagged:
Answers
What alert are you experiencing? I ask this question as SQL Monitor does not have a specific TDE database alert.
Is the alert in question from a custom metric previously configured? If the answer is yes, would it be possible to obtain the DDL for this custom metric?
Many Thanks
Eddie
Senior Product Support Engineer
Redgate Software Ltd
Email: support@red-gate.com