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 – Reasons – Not Able to Shrink the Transaction Log
Recently during consulting engagement Comprehensive Database Performance Health Check, my client asked if I knew why they could not shrink the transaction log.
SQL SERVER – Available Free Space in Data and Log File
Lots of good feedback, I have received on my recent to the point blog posts. Today we will see a script for Available Free Space in Data and Log File.
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 – Who Dropped Table? Part 2
There is a way to find out few more things. However, before we continue I strongly suggest that you watch the following video about the dropped table.
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 – Simple Recovery Model and Restrictions
I received a question from a client that they want to move their database from the Full Recovery Model to the Simple Recovery Model, can they do it?