How to check on which drive the DB is saved?

Question

How can I check whether the Compass/myQA DBs are saved on the C or another drive?

Answer

Step 1

Open the SQL Server Management Studio and connect to the right instance.

Step 2

Right click on the instance - New Query

Step 3

Copy following lines in the query tab:

SELECT name, physical_name AS CurrentLocation, state_desc
FROM sys.master_files
WHERE database_id = DB_ID(N'IBADosCompassConfig');

Attention: Replace the bold and italic written IBADosCompassConfig with the DB name you want to check. 

Step 4

Hit execute - the location will be shown immediately.