The log file is not just that stores information, this is mainly responsible for data consistency. This file stores all the transactions that modify/add data in the database.       Log files has…

The page is the basic building block of storage in SQL server. Data is stored in datafiles (.mdf and .ndf).  Storages are built by group of pages, logically speaking data…

SQL Server database is a logical collection of data. In SQL Server, data is stored in two set of files, Data files and Log files. When we create a database…