If you want to figure out where one or all of your SQL databases files are stored on your disks, the easiest way is:
- Launch SQL Server Management Studio and sign in
- Right click on any database
- Select NEW QUERY
- Enter select name ‘file name’, physical_name ‘file location’ from sys.master_files
- 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?