Virtual Log Files (VLFs) are internal divisions of physical log files created by the SQL Server Database Engine. They have no fixed size.
SQL SERVER 2022 and Instant File Initialization for Log File
This blog post will explore how Instant File Initialization for Log File growth events in SQL Server 2022.
SQL SERVER – Logs are Full and Can’t Switch Recovery Models
His question was about their database Logs, which were Full and they Can’t Switch Recovery Models. Let us discuss this problem today.Â
SQL SERVER – Delayed Durability and Flushing Log Files
Today we will be seeing a simple solution of Delayed Durability and Flushing Log Files. Comprehensive Database Performance Health Check.
SQL SERVER – Running Log Backup While Taking Full Backup
They found out that they have a full backup running for one of the largest servers and at the same time they are running a log backup on the same server.
SQL SERVER – Multiple Log Files to Your Databases – Not Needed
I was asked a very interesting question by their DBA about log files. The question was – Is there ever need of multiple log files in SQL Server?
SQL SERVER – Error 9002: The Transaction Log for Database ‘SQLAuthority’ is Full Due to ‘REPLICATION’
In this blog, I would explain the cause and fix of error: The transaction tog for database ‘SQLAuthority’ is full due to ‘REPLICATION’.