CREATE DATABASE DB_SALES
— TWO FILES ARE AUTO CREATED.
— DATA FILE(mdf) ++ LOG FILE OR TLOG FILE OR AUDIT LOG FILE (ldf)
— ADDITIONALLY WE CAN CREATE MORE FILES (ndf)
— THE DATA FILES INTERNALLY CONTAIN “PAGES”
— SIZE OF EACH PAGE = 8 KB
— A COLLECTION OF 8 CONSECUTIVE PAGES = EXTENT
— A GROUP OF FILE IS CALLED “FILEGROUP”
— THE LOG FILES INTERNALLY CONTAIN “PAGES”
— A COLLECTION OF FEW CONSECUTIVE PAGES = “VIRTUAL LOG FILES”
— START LOCATION OF EVERY VIRTUAL LOG FILE IS CALLED “MINI LSN”
— LSN : LOG SEQUENCE NUMBER