Sep 2025 Discount: Comprehensive Database Performance Health Check | Testimonials

Home

SQL SERVER – Unable to Bring SQL Cluster Resource Online – Online Pending and then Failed

Pinal Dave
SQL Tips and Tricks
SQL High Availability, SQL Server, SQL Server Cluster

Here is the situation which my client explained and I was asked for help about SQL Cluster Resource.

Hi Pinal,
We are having 2 node windows cluster having 3 SQL Server instances clustered running on Windows 2012 R2 on VMware. We have one instance that will start from the services.msc but not from the Failover Cluster Manager when attempting to bring the service online. In reality the services start because during the ‘Online pending’ I am able to connect and query the databases on that instance, although it is in the ‘Online pending’ state.

Do you know what could be the problem?

Read More

SQL SERVER – Performance Monitoring for Analysis Services – Notes from the Field #093

Pinal Dave
SQL Tips and Tricks
Notes from the Field, SQL Backup and Restore, SQL Server

[Note from Pinal]: This is a new episode of Notes from the Field series. When we build an application, we build it with zeal and enthusiasm. We believe it will do well for many years but it is not the case always. After a while performance started to go down and everything is not in the best shape. This is the time when we need to monitor performance and take action based on our analysis.

Read More

SQL SERVER – Error: Msg 4305, Level 16, State 1 – The log in this backup set terminates at LSN, which is too early to apply to the database.

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
SQL Error Messages
While working with transaction log backup restore or log shipping, you must have seen below error message. Msg 4305, Level 16, State 1, Line 47 The log in this backup set begins at LSN 33000000048000001, which is too recent to apply to the database. An earlier log backup that includes…
Read More

Interview Question of the Week #031 – How to do Case Sensitive SQL Query Search

Pinal Dave
SQL, SQL Interview Questions and Answers, SQL Server, SQL Tips and Tricks
SQL Collation
Question – How to do case sensitive search on any column of the table? Answer – If Column1 of Table1 has following values ‘CaseSearch, casesearch, CASESEARCH, CaSeSeArCh’, following statement will return you all the four records. SELECT Column1 FROM Table1 WHERE Column1 = 'casesearch' To make the query case sensitive and…
Read More