Download Android App in your Android Device from Google Play Store
- Search for "Withoutbook Practice Exam Test" in Mobile/Tablet Play Store
Practice InterviewNew Search by Name or Email

Exams Attended

Make Homepage

Bookmark this page

Subscribe Email Address

MSSQL Interview Questions and Answers

Ques. Where is my database stored on the hard disk in MS SQL Server?
Ans. 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:

USE withoutbookdb

SELECT type_desc, physical_name, size
FROM sys.database_files
type_desc physical_name size

ROWS c:Program FilesMicrosoft SQL Server
MSSQL.1MSSQLDATAwithoutbookdb.mdf 152

LOG c:Program FilesMicrosoft SQL Server
MSSQL.1MSSQLDATAwithoutbookdb_log.LDF 63

Go verify these two files with Windows Explorer.
Is it helpful? Yes No

Most helpful rated by users:

©2020 WithoutBook