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?


Leave a Reply

Avatar placeholder

Your email address will not be published. Required fields are marked *