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.
SQL SERVER – How to Fix log_reuse_wait_desc – AVAILABILITY_REPLICA?
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’
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’.
What Part of the SQLDump Suggest Database Corruption? – Interview Question of the Week #188
Question: What Part of the SQLDump Suggest Database Corruption?
SQL SERVER – Useful Queries – Why Huge Transaction Log (LDF) File? Fix Low Disk Free Space on the Drive Used by LDF Files
During my Comprehensive Database Performance Health Check engagement with the client, one of the most common issue found was the huge size of the transaction log file. In this blog, we would learn about useful queries which I use to help my client in fixing Huge Transaction Log (LDF) File.
How to Enable Files & Folders Level Auditing in SQL Server? – Interview Question of the Week #176
Question: How to Enable Files & Folders Level Auditing in SQL Server?
SQL SERVER – Impact of Transaction on the Free Log Space
Earlier I wrote a blog post about SQL SERVER – How to Find Free Log Space in SQL Server? After reading this blog post, I received the following question from one of the users about the impact of the transaction on the free log space.