0 Replies Latest reply on Mar 12, 2017 1:42 AM by er.vansh17091

    Re: Alerts/Monitoring VM server.


      Hello Team,


      Could you please tell me process to make a alert for below queries.


      Error log file location on server(VMSOLVxxxxxx) :‘D:\Program Files\Microsoft SQL Server\MSSQL13.MSSQLSERVER\MSSQL\Log\ERRORLOG’




      Key words to be monitored:


        1. Operating system error


        1. backup failed to complete the command backup log


        1. backup failed to complete the command backup database


        1. database log truncated


        1. backup log with truncate_only or with no_log


        1. setting database option recovery to simple


        1. the metadata is inconsistent


        1. succeeded after failing


        1. cannot be opened due to inaccessible files or insufficient memory or disk space


        1. backup sets on the media might be damaged and unusable


        1. A no recoverable i/o error occurred on file


        1. because the log is out of space


      An inconsistency was detected during an internal operation


      You can mail me        er.vansh1709@gmail.com