SQL job (email) alert to warn of disk getting full

RayPaks 26 Reputation points
2020-08-24T04:24:51.263+00:00

I am trying to create an alert from SQL server to send me an email when the log or data files for a database are almost about to fill up the disk they reside on.
Is anyone able to help with this?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
8,560 questions
No comments
{count} votes

Accepted answer
  1. AmeliaGu-MSFT 13,881 Reputation points
    2020-08-24T08:35:29.58+00:00

    Hi RaymondPakure-9310,

    You can create a performance condition alert, then select Percent Log Used as Counter and define threshold for the alert.
    You also can create an event alert using error 1105.
    For more details, please refer to Managing Database Data Usage With Custom Space Alerts which might help.

    Best Regards,
    Amelia


0 additional answers

Sort by: Most helpful