How do I find the location of a SQL database?

Question

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.

How do I find the location of a database file?

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 database in SQL?

Use SQL Server Management Studio1In Object Explorer, connect to an instance of the SQL Server Database Engine, and then expand that instance.2To see a list of all databases on the instance, expand Databases.

Expert · Answer

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.

Expert · Answer

Use SQL Server Management Studio1In Object Explorer, connect to an instance of the SQL Server Database Engine, and then expand that instance.2To see a list of all databases on the instance, expand Databases.

How do I find the location of a SQL database?

How do I find the location of a database file?

How do I find the database in SQL?

Related Questions