Files Created in DATABASE

Files Created in DATABASE 

Two Types of files are created in Database : 

.mdf :Microsoft Datbase File (This is primary file ) 

.ldf : log database files 

Two types of objects are formed in MDF  : USER DEFINED  AND SECOND IS SYSTEM DEFINED . 

LDF IS BASICALLY FOR STORING AND RETRIEVING DATA .

THESE FILES LDF AND MDF ARE ON DIFFERENT LOCATIONS. 

LDF IS USED FOR SECURITY  PURPOSE  BY DEFAULT IT IS STORED IN ONE FOLDER :  DATA FOLDER  

PROGRAM FILES => MSSQL SERVER => MSSQL => DATA FOLDER =>. MDF AND LDF