One of my clients contacted me for quick assistance. They were trying to install a Service pack for SQL Server 2016 instance, but it was failing with below error message about cluster service.
SQL SERVER – Maintenance Plan Error: Cannot Create a Task From XML For Task, Eue to Error 0x80070057. The Parameter is Incorrect. (OnPreExecute)
Once I encountered an error while creating new maintenance plans on my virtual machine.
SQL SERVER – Don’t Ignore Warning: Cluster Resource DLL Update Restart Check
This was one of the hard lessons learned, so I am sharing with blog readers. This is about an error in cluster resource DLL.Â
While applying the patch to SQL instance, I cluster, sometimes we get warning “Cluster Resource DLL Update Restart Check.” If we check Detail.txt file in setup logs, we will find below.
SQL SERVER – Unable to Connect to SQL Server in Azure Virtual Machine from SSMS on On-Premise Machine
From past few months, I am seeing a few of my client moving their development workload to Cloud. When I asked the reason, it was mostly cost reduction in terms of hardware lifetime, licensing and connectivity advantage and their developer can work from anywhere. In this blog post, we will learn about how to fix error related to Azure Virtual Machine.Â
SQL SERVER – Script Level Upgrade for Database ‘master’ Failed Because Upgrade Step ‘sqlagent100_msdb_upgrade.sql’ – Error: 5041: MODIFY FILE Failed
I have helped many clients in upgrade failures via my On-Demand consulting and I am amazed to see various ways which can break SQL Server upgrade. In this blog we would learn about fixing error Script level upgrade for database ‘master’ failed because upgrade step ‘sqlagent100_msdb_upgrade.sql’
SQL SERVER – Full-Text Search Not Working For PDF Documents
Full-Text is a feature of SQL Server which allows linguistic search in various languages. In general, we use LIKE operator to search inside the column data, but it is not very efficient. There are multiple advantages of full-text search. You can read more about this on my blog Creating Full-Text Catalog and Full-Text Search
SQL SERVER – Installation Error: The Cluster Resource is Not Available. (Exception from HRESULT: 0x8007138E)
Sometimes DBAs get into a situation where they don’t know what the next steps is to fix the issue. Here is one of the situation where DBA contacted me with below error in installing a patch for SQL Server in clustered environment. If you don’t know then I can tell you that I do provide quick consultancy. You can read more here On Demand (55 minutes). In this blog post we will learn about how to fix an installation error.Â