In the DATA folder for SQL Server (Windows Server 2008):
C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA
There are two files:
xxx.ldf (63.7GB) xxx.mdf (5.38GB)
(Incidentally why is the size in the info bar at the bottom of the windows explorer screen vastly different to the 'size' column information? The .ldf file size shows a 4GB difference).
There is no corresponding database by that name (xxx).Is there a query on system tables that I can run to show an output of:
DB name | mdf name | log name yardi | xxx.mdf | xxx.ldf test | test.mdf | test.ldf prpdb | prpdb.mdf | prpdb.ldf etc
I suspect that the yardi DB is related to the xxx .mdf / .ldf files, this particular database we get a .mdf dump that we restore from every morning.
==== EDIT IN RESPONSE TO ANSWERS ====
Two view are mentioned in the answers below (that I only ran in context of the master DB)
These views are relatable by the field
database_id, and surprisingly I had to use both views because the name columns in each were different.
sys.databases.namecorresponded to the names I see in SSMS
sys.master_files.namedid not correspond to the names I was seeing on the databases
The query that solved my problem is this:
USE master; GO SELECT ds.[name] as [Database name (as in SSMS)], mf.[name] as [master_files name], mf.physical_Name as [File name], mf.SIZE * 8 / 1024 AS SizeMB FROM sys.master_files mf LEFT OUTER JOIN sys.databases ds ON mf.database_id = ds.database_id ORDER BY ds.name ASC, SizeMB DESC
==== AND ====
The SizeMB returns a completely different size of the log file compared to what is seen in windows explorer 'size' column, and is also different to the info bar in windows explorer. By several GB. Why?