How to find the filesystem location of an MS-SQL database

  1. Open SQL management studio
  2. Login with a valid username and password
  3. Expand “Databases”
  4. Right-click on the database in question and choose “Properties”
  5. In the left navigation pane, choose “Files”
  6. On the right details pane, scroll horizontally until you see “Path” -> this is the location of the SQL database and log files
  7. Highlighting the path and pressing ctrl-c will copy the path to the clipboard