Transaction Log Archives - SQL Authority with Pinal Dave

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

December 19, 2018

Pinal Dave

SQL

Shrinking Database, SQL Error Messages, SQL Log, SQL Scripts, SQL Server, Transaction Log

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.

SQL SERVER – How to Fix log_reuse_wait_desc – AVAILABILITY_REPLICA?

September 18, 2018

Pinal Dave

SQL Tips and Tricks

AlwaysOn, SQL Replication, SQL Scripts, SQL Server, Transaction Log

Earlier this week I had multiple engagements of Comprehensive Database Performance Health Check. While working with one of the customers we realized that when we query sys.databases for one of the databases, we always see column log_reuse_wait_desc containing reasons AVAILABILITY_REPLICA. The customer was really curious about what it means. Let us see what we found out after quick research.

SQL SERVER – Rebuild Index Job Failed – Error: 9002 – The Transaction Log for Database ‘PinalDB’ is Full Due to ‘LOG_BACKUP’

September 10, 2018

Pinal Dave

SQL

SQL Backup, SQL Error Messages, SQL Index, SQL Log, SQL Server, Transaction Log

Sometimes we have an error in SQL Server job history which are not very accurate to find the cause of an issue. In this blog we would explore a situation where rebuild index job was failing with error 9002 – The transaction log for database ‘PinalDB’ is full due to ‘LOG_BACKUP’.