How can we help you today? How can we help you today?

Monitoring snapshot databases?

Hi, have found in extended logs exception that SQL Monitor constantly failing while trying to get info of snapshot database log file.
Could not locate file '2' for database 'MyDatabaseName' in sys.database_files. The file either does not exist, or was dropped.

As snapshot DB doesn't have log file, could you fix this check not to generate exceptions, thanks?

gopogoc
0

Comments

4 comments

Sort by
  • Alex B
    Hi @gopogoc

    What version of SQL Monitor are you using?  And to confirm, have you created an Extended Events log file that is capturing this message or is this in the SQL Server errorlog that you are seeing this message?

    Kind regards,
    Alex
    Alex B
    0
  • gopogoc
    Hi, current version of SQL Monitor is:
    Version 11.0.5.3446 (Updates available - SQL Monitor 11.0.9)

    Errors are captured in events log file, catching  Exception type of Error and Warning,
    it is also catch able on Profiler on SQL server that SQL monitors and if you have database snapshot



    gopogoc
    0
  • Alex B
    Hi @gopogoc

    Thank you for that! We can see this happening as well and I have raised SRP-13561 to track the issue but currently I have no eta for when any change may be made to address this.  I will update here when I have further information on the team.

    Kind regards,
    Alex
    Alex B
    0
  • DanC
    Hi @gopogoc

    Just reaching out on behalf of my colleague Alex, the issue has now been resolved in 11.1.3 released today.

    https://documentation.red-gate.com/sm/release-notes-and-other-versions/sql-monitor-11-1-release-notes

    DanC
    0

Add comment

Please sign in to leave a comment.