Monitoring snapshot databases?

gopogocgopogoc Posts: 3 New member
in Redgate Monitor
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?

Tagged:
· Share on Twitter

Best Answers

Answers

  • Alex BAlex B Posts: 1,158 Diamond 4
    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
    Product Support Engineer | Redgate Software

    Have you visited our Help Center?
    · Share on Twitter
  • gopogocgopogoc Posts: 3 New member
    edited December 17, 2020 9:17AM
    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



    · Share on Twitter
Sign In or Register to comment.