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
