SQL Server

Virtual Log File and the transaction log fileVirtual Log Files (VLF)Anatomy of a transaction log file – VLF blocks The size and number of VLF… Read More »SQL Server Virtual Log Files (VLF)

• What is a transaction log file –file to record all changes to the database• Why backup transaction log file — to clear the transaction… Read More »SQL Server sizing Transaction log

What is a database file?      When you create a database, two primary files are created by default: the data file and the transaction log… Read More »SQL Server Data and Log Files

Each time you install any SQL Server Edition on a server; there are four primary system databases, each of which must be present for the… Read More »SQL Server System Databases