- Solutions
-
- File Server: Ransomware Protection
- File Server: File Copy
- File Server: Audit File Access
- File Server: Storage growth reporting
- Licensing/Pricing
- Contact
Database Monitor
The Database Monitor is really two monitors - the Database Server Monitor, and one or more Database Monitors. Currently Microsoft's SQL Server is the only database supported.
Database Server Monitor
The Database Server Monitor is always created first, and it is used to create individual Database Monitors. After a valid connection string is entered, the list of databases on the database server are displayed.
For help coming up with the proper connection string, please see:
https://www.connectionstrings.com/sql-server/
In this step, you do NOT need to specify a Database parameter yet. So one of the two connection strings below will probably work:
Using Trusted_Connection
Driver={SQL Server Native Client 10.0}; Server=<your_servername_here>; Trusted_Connection=yes;
Using Username/Password
Driver={SQL Server Native Client 10.0}; Server=<your_servername_here>; UID=<your_username>; PWD=<your_password>;
The check boxes on the monitor control what it will alert on, specifically it can alert when:
- databases are created
- databases are deleted
- database online status changes
- a monitored database goes offline
This monitor also shows which individual databases are being monitored, and lets you start or stop monitoring those databases via a Database Monitor.
Database Monitor
When you start monitoring a new database, a Database Monitor is automatically created. After it is created, you can go straight to the Database Monitor to edit the configuration or even delete the monitor.
The connection string is automatically generated for you based on the connection string used in the Database Server Monitor above. You can edit it as needed.
The Database Monitor has two tabs that control what it will watch. It can watch and alert on the status which involves the database's backup and recovery model. To watch that the database itself is up, use the Database Server Monitor above.
The other tab lets you monitor the size of the database and its transaction log.
Standard Configuration Options
Like all monitors, this monitor has standard buttons on the right for Adding Actions, setting Advanced Options and setting the Monitor Schedule.