I have found a mysterious NDF file in my DB. Can't tell if it contains valid data or if the file is dead.
I'd like to remove it but I cannot tell if the file is in use by SQL Server. Windows Last Modified Date is 2 years ago, but for SQL files that is not reliable because SQL uses it's own drivers to access its files.
How can I tell what the last access time (either to read or to write) is for particular NDF file in a db?