Question: What is the Difference between TRUNCATE and DELETE in SQL Server?
SQL SERVER – Unable to Add Server Name SQLAUTH-LISTENER to Transport Device NetBt_If4 Status 2 – Windows Cluster
During one of my consulting engagement about Always On availability group configuration, I found that listener network name was not coming online. As a rule of thumb, I always generate cluster log for any error related to cluster. SQL SERVER – Steps to Generate Windows Cluster Log?
SQL SERVER – Logon Failure: The User has not Been Granted the Requested Logon Type at This Computer
Sometimes DBA do something which they are not aware of and end up in looking at the logs to see what went wrong. Here is one of the articles I wrote about the changing service account from configuration manager. Why to Use SQL Server Configuration Manager Over Services applet (services.msc)? – Interview Question of the Week #112. In this blog post, let us learn how to fix logon failure error.
SQL SERVER – Slow Installation Wizard on Cluster – Please Wait While Microsoft SQL Server 2016 Setup Process the Current Operation
Have you come across a situation where setup is taking many hours while navigating from one screen to another in clustered environment? Have you ever waited for many hours watching following message related to slow installation wizard on cluster?
SQL SERVER – Script Upgrade Failure – RsFxFt.Dll::RsFxMgmtInitialize failed: Error 0x80070002
In the recent few days, I have found many clients having various script upgrade failures while applying service packs or cumulative updates. Here are few of them. Let us learn about Script Upgrade Failure.
SQL SERVER – Service Pack Error – Attributes do not Match
My virtual machines are my play grounds for any research. A few days ago, on my lab machine, I was having difficulties applying latest service pack. I followed the documentation and looked at the files. In this blog post we will take a look at the service pack error. Here is what I found in Summary.txt
SQL SERVER – FIX: Error: 913, Severity: 16 – Could Not Find Database ID 3. Database May Not be Activated Yet or May be in Transition – SQL Service
This blog is a result of a Skype conversation with one of my clients. The issue, for which they contacted me, was that they were not able to stat SQL Service due to database may not be activated.
How to Change Owner of Database in SQL SERVER? – Interview Question of the Week #117
Question: How to Change Owner of Database in SQL SERVER?
SQL SERVER – Unable to Install Service Pack in Cluster – There was an Error to Lookup Cluster Resource Types
Learning never stops for me with SQL Server. Even though I have written articles to solve many issues, I still get pinged from various clients and I find one new thing every day. In this blog post we will learn how to fix the error related to installing the service pack in the cluster.
SQL SERVER – Unable to recycle Errorlog – sp_cycle_errorlog – OS error 1392
One of my clients contacted me and informed that they have a node production clustered server and they recently noticed that the nightly error log had stopped cycling ERRORLOGs. When we attempted to run sp_cycle_errorlog we get the following: