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’.
SQL SERVER – Query to List Active and Inactive VLF
During the Comprehensive Database Performance Health Check, I had also helped the client build a query to list active and inactive VLF.
SQL SERVER – Error 35296: Log Backup for Database “SQLAuthority” on Secondary Replica Failed Because the New Backup Information Could Not be Committed on Primary Database
Log backup for database “SQLAuthority” on secondary replica failed because the new backup information could not be committed on the primary database.
SQL SERVER – Huge Space Used by Table sysxmitqueue in MSDB. How to Clear it Quickly?
Recently I was helping a customer who hired me for my services. He had an issue where they noticed that the size of the MSDB database has grown huge.