Home >> FAQs/Tutorials >> SQL Server FAQ
SQL Server FAQ - Location of Database Files
(Continued from previous topic...)
Where is my database stored on the hard disk?
If a database is created with simple CREATE DATABASE statement,
the server will create two database files on the hard disk to store data and configuration
information about that data bases:
- database_name.mdf - SQL Server Database Primary Data File
- database_name_log.ldf - SQL Server Database Transaction Log File
To find out the location of database files, you can query the
"sys.database_files" view as shown in this tutorial example:
SELECT type_desc, physical_name, size
type_desc physical_name size
ROWS c:\Program Files\Microsoft SQL Server
LOG c:\Program Files\Microsoft SQL Server
Go verify these two files with Windows Explorer.
(Continued on next topic...)
- What is a database?
- What is the simplest way to create a new database?
- How to set the current database?
- How to delete a database?
- Why I am getting this error when dropping a database?
- How to get a list all databases on the SQL server?
- Where is my database stored on the hard disk?
- How to create database with physical files specified?
- How to rename databases?
- Why I am getting this error when renaming a database?
- What are database states?
- How to set a database state to OFFLINE?
- How to move database physical files?
- How to set database to be READ_ONLY?
- How to set database to be SINGLE_USER?
- What are system databases?