Collections:
Location of Database Files in SQL Server
Where is my database stored on the hard disk in SQL Server?
✍: FYIcenter.com
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:
To find out the location of database files, you can query the "sys.database_files" view as shown in this tutorial example:
USE FyiCenterData GO SELECT type_desc, physical_name, size FROM sys.database_files GO type_desc physical_name size ROWS c:\Program Files\Microsoft SQL Server \MSSQL.1\MSSQL\DATA\FyiCenterData.mdf 152 LOG c:\Program Files\Microsoft SQL Server \MSSQL.1\MSSQL\DATA\FyiCenterData_log.LDF 63
Go verify these two files with Windows Explorer.
⇒ Creating Databases with Specified Physical Files in SQL Server
⇐ Getting a List of All Databases on the Server in SQL Server
2016-11-24, 1539🔥, 0💬
Popular Posts:
What Happens to Your Transactions When ERROR 1205 Occurred in MySQL? If your transaction receives th...
Where to find answers to frequently asked questions on Transaction Management: Commit or Rollback in...
What is dba.FYIcenter.com Website about? dba.FYIcenter.com is a Website for DBAs (database administr...
How To Use SQL*Plus Built-in Timers in Oracle? If you don't have a stopwatch/timer and want to measu...
How To Generate CREATE TABLE Script on an Existing Table in SQL Server? If you want to know how an e...