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.
SQL SERVER – Getting Started with Accelerated Database Recovery – Instant Rollback
There are many reasons to envy my job as SQL Server Performance Tuning Expert Consultant but the most important reason is that I get to work on quite often the latest version of SQL Server. Just the other day I had an early adopter customer who was using SQL Server 2019 for their environment and they wanted me to help them with the new feature of Accelerated Database Recovery.
SQL SERVER – Cannot Shrink Log File Because Total Number of Logical Log Files Cannot be Fewer than 2
Since I wrote my article about the script of shrinking the Log Files, there have been many emails from my blog readers about various messages which they are seeing during shrink. I have been sharing them with other blog readers as well. In this blog, we would discuss a message Cannot shrink log file because a total number of logical log files cannot be fewer than 2.