"No SQL files on this disk" message on drive that contains transaction log files?
kwbell
Posts: 2 New member
I'm still learning my way around SQL Monitor so maybe I'm missing something obvious, but I thought I'd go ahead and ask anyway. While reviewing the Disk Usage page under the Estate tab for one of my SQL 2014 servers, I clicked on one of the drives listed and got the message "No SQL files on this disk". Which is weird because the drive hosts the transaction log files for the user databases on this server. If I log onto the server and navigate to this drive I can see the '.ldf' files, so I know they are in fact there. If I click on the other drive listed, I can see the '.mdf' and '.ndf' files (as well as the '.ldf' files for the SQL system databases). I've checked several of the other monitored servers and so far this appears to only be happening on this one particular server. Thoughts or suggestions please? Thanks in advance.
Answers
Can you confirm what version of SQL Monitor that you're using?
We have a fix for disk usage in 9.2.12 so it'll be very helpful if you could upgrade and check again.
Sean Quigley | Product Support Engineer | Redgate Software
Have you visited our Help Center?
Let me know if the upgrade helps to fix your issue.
Sean Quigley | Product Support Engineer | Redgate Software
Have you visited our Help Center?