Recently during consulting engagement Comprehensive Database Performance Health Check, my client asked if I knew why they could not shrink the transaction log.
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.
His question was about their database Logs, which were Full and they Can’t Switch Recovery Models. Let us discuss this problem today.
Today we will be seeing a simple solution of Delayed Durability and Flushing Log Files. Comprehensive Database Performance Health Check.
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?
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.