Feb 2023 Discount: Comprehensive Database Performance Health Check | Testimonials

  • Consulting
  • Training
  • Free Videos
  • All Articles
    • Interview Questions and Answers
    • SQL Tips and Tricks
    • SQL Performance
    • SQL Puzzle
    • Big Data
    • Blog Stats
    • SQL Books
    • Search SQLAuthority
  • Downloads
  • Hire Me
  • Health Check
  • Training
Recovery Models

SQL SERVER – Logs are Full and Can’t Switch Recovery Models

August 2, 2021
Pinal Dave
SQL Tips and Tricks
Recovery Model, SQL Log, SQL Server, Transaction Log

His question was about their database Logs, which were Full and they Can’t Switch Recovery Models. Let us discuss this problem today. 

Read More
Flushing Log

SQL SERVER – Delayed Durability and Flushing Log Files

December 30, 2020
Pinal Dave
SQL Tips and Tricks
SQL Log, SQL Scripts, SQL Server, SQL Stored Procedure, Transaction Log

Today we will be seeing a simple solution of Delayed Durability and Flushing Log Files. Comprehensive Database Performance Health Check.

Read More
running log backup

SQL SERVER – Running Log Backup While Taking Full Backup

September 19, 2020
Pinal Dave
SQL Tips and Tricks
SQL Backup, SQL Log, SQL Restore, SQL Server, Transaction Log

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.

Read More
multiple log files

SQL SERVER – Multiple Log Files to Your Databases – Not Needed

April 11, 2020
Pinal Dave
SQL Tips and Tricks
SQL FileGroup, SQL Log, SQL Scripts, SQL Server, Transaction Log

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?

Read More
full-due-to-replication

SQL SERVER – Error 9002: The Transaction Log for Database ‘SQLAuthority’ is Full Due to ‘REPLICATION’

March 23, 2020
Pinal Dave
SQL
SQL Error Messages, SQL Log, SQL Replication, SQL Scripts, SQL Server, Transaction Log

In this blog, I would explain the cause and fix of error: The transaction tog for database ‘SQLAuthority’ is full due to ‘REPLICATION’.

Read More
Inactive VLF

SQL SERVER – Query to List Active and Inactive VLF

March 12, 2020
Pinal Dave
SQL Performance
Shrinking Database, SQL Log, SQL Scripts, SQL Server, SQL Server DBCC, Transaction Log

During the  Comprehensive Database Performance Health Check, I had also helped the client build a query to list active and inactive VLF.

Read More
secondary replica

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

August 1, 2019
Pinal Dave
SQL
AlwaysOn, SQL Backup, SQL Error Messages, SQL High Availability, SQL Log, SQL Server, Transaction Log

Log backup for database “SQLAuthority” on secondary replica failed because the new backup information could not be committed on the primary database.

Read More
1 2 3 4 Next
  • SQL Interview Q & A
  • Testimonials
  • Search
  • Privacy Policy

© 2006 – 2023 All rights reserved. pinal @ SQLAuthority.com

Go to mobile version