How to view SQL Server database file locations?

You have two native options for finding out where the SQL server stores its database files: either right-click on the instance name in SQL Server Management Studio (SSMS) and navigate to the 'Database Settings' tab, or use a T-SQL query. If you ever need to know where your database files are located, run the following T-SQL code: USE master; SELECT name 'Logical Name', physical_name 'File Location' FROM sys.master_files; This will return a list of all data files and log files for the SQL Server instance. Here’s what it looks like when I run that code in SQL Operations Management .

How to find the default location for data files in SQL Server?

Here’s how to find the default location for data files and log files in SQL Server. If you only need to find the location of the files for a particular database, you can query the sys.database_files system catalog view instead. Simply switch to the applicable database and run the query.

Where are my database files located in T-SQL?

February 14, 2020. by Ian. If you ever need to know where your database files are located, run the following T-SQL code: USE master; SELECT name 'Logical Name', physical_name 'File Location' FROM sys.master_files; This will return a list of all data files and log files for the SQL Server instance.

How do I find the location of a specific database?

Find Files for a Specific Database If you only need to find the location of the files for a particular database, you can query the sys.database_files system catalog view instead. Simply switch to the applicable database and run the query.

How to find the location of data files and log files?

How to Find the Location of Data Files and Log Files in SQL Server. If you ever need to know where your database files are located, run the following T-SQL code: This will return a list of all data files and log files for the SQL Server instance. Here’s what it looks like when I run that code in SQL Operations Management Studio on a Mac: