You can configure different roles to send you an email notification when their database
space is running low.
Before you begin
To make sure that the email notification is sent, configure the
SMTP and
Watchdog settings on the server
hosting the role.
What you should know
All role database notifications are configured from Config Tool, except for the Directory database, which
must be configured in the
Database properties on the
Server Admin - Main Server page. The
procedures are similar, so only the configuration from Config Tool is described here.
Procedure
-
From the Config Tool homepage, open the System task and click the
Roles view.
-
Select a role, and click the Resources tab.
-
Click Notifications ().
-
In the dialog box that opens, set the following options:
- Disk space
- Sends a notification when the remaining free space on the disk falls below a
certain threshold (in GB).
- Database usage
- Sends a notification when the space used by the role's database reaches a certain
percentage. This option is only for the Express edition of SQL Server, whose
database size is limited to 10 GB. If you are using a full edition of SQL Server,
this option has no effect.
-
Click OK.