0

Recently one of the database tables got corrupted in production's SQL server. I am trying to create an alert for this kind of issue. I don't see exact Error number or severity to choose from while creating alert. How can I foresee or set and Alert in SQL Server for this kind of issue when they happen?
please help

Appreciate your responses.

1
  • How did you find out that "one of the database tables got corrupted"? Use the same logic.
    – mustaccio
    Mar 31, 2022 at 16:10

1 Answer 1

2

for free

I publish a script at my GitHub repository to set up alerts for high severity and corruption errors.

It assumes a couple things:

  • You are using a version and edition of SQL Server that supports database mail
  • You have the CHECKSUM page verification option enabled on databases you care to get alerted about corruption in

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.