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.
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:
SQL SERVER – Msg 3136, Level 16 – This Differential Backup Cannot be Restored Because the Database has not Been Restored to the Correct Earlier State
I was trying to teach copy-only backups to my students and encountered below error related to differential backup.
SQL SERVER – System. Security. Cryptography. CryptographicException – There Was an Error Generating the XML Document
One of my clients contacted me in assistance to install SQL Server. Generally, this is straightforward, but sometimes there are problems. This time we received an error message and it was very interesting. Let us learn about error related to the XML Document.