SQL Server Virtual Log Files (VLF)
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)
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