How do I find the database file in SQL Server?

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.

Where is my SQL Server database stored?

SQL Server databases are stored in the file system in files. Files can be grouped into filegroups. For more information about files and filegroups, see Database Files and Filegroups. When people gain access to an instance of SQL Server they are identified as a login.

How do I view a database file?

In Windows Explorer, navigate to the drive or folder containing the Access database file you want to open and double-click the database. Access starts and the database is opened.

Expert · Answer

SQL Server databases are stored in the file system in files. Files can be grouped into filegroups. For more information about files and filegroups, see Database Files and Filegroups. When people gain access to an instance of SQL Server they are identified as a login.

Expert · Answer

In Windows Explorer, navigate to the drive or folder containing the Access database file you want to open and double-click the database. Access starts and the database is opened.

How do I find the database file in SQL Server?

Where is my SQL Server database stored?

How do I view a database file?

Related Questions