Sep 2025 Discount: Comprehensive Database Performance Health Check | Testimonials

Home

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

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’.

Read More

SQL Authority News – Brent Ozar Unlimited Office Hours 2018/4/4 – Fun Experience

Pinal Dave
SQLAuthority News
Brent Ozar, Clustered Index, Database Mail, SQL Index, SQL Performance, SQL Replication, SQL Training

It was my pleasure and honor that I was invited to the Brent Ozar Unlimited Office Hours. During the office hours, we received quite a few interesting questions, some were very complicated and some were super fun. However, the best part of attending the office hours was the company. I was fortunate to have Brent, Richie, and Tara along with me in this office hours. Please note that the questions which we discussed during the session were asked live.

Read More

Practical Real World Performance Tuning – Frequently Asked Questions

Pinal Dave
SQLAuthority News
Brent Ozar, SQL Index, SQL Performance, SQL Server, SQL Training

Earlier this month, I announced my very first online live training course Practical Real World Performance Tuning along with Brent Ozar.  As soon as the course was announced we received your overwhelming response. I am truly thankful to you to fill up the available seats very quickly. While I am writing this blog posts, we have very few limited seats are available. One the seats are filled up, we will have to close the registration. If you miss this opportunity this year, do not worry, you can always register in the future when we return again in 2019 or 2020.

Read More