SOLVED: VIDEO: How To Find Database Location in SQL Server Management Studio

If you want to figure out where one or all of your SQL databases files are stored on your disks, the easiest way is:

1. Launch SQL Server Management Studio and sign in
2. Right click on any database
3. Select NEW QUERY
4. Enter select name ‘file name’, physical_name ‘file location’ from sys.master_files
5. Click the EXECUTE button

• Where are sql database MDF files located?
• List all MDF database locations?
• How to find the MDF file locations?
• Where are mdf files stored?