During my consulting, I guide my clients to have a backup plan in place. One of my clients reported that whenever they try to take a Full Backup of a database, it fails precisely after 60% completion. Here is the error message while making database backup using SQL Server Management Studio. Let us fix error related to the bad middle sector in this blog.
How to Reduce High Virtual Log File (VLF) Count? – Interview Question of the Week #162
Question: How to Reduce High Virtual Log File (VLF) Count?
SQL SERVER – Installation Wizard Hang Forever – Please Wait on Feature Selection Page
Here is one of the situations which I encountered with SQL Server 2014 on Windows Server 2012 R2. I wanted to add “Analysis Services” features to an existing installation. I came up with the feature selection screen on SQL setup and pressed next it hangs with “Please Wait”. I click on it and went for lunch, when I came back, it was still in the same state. Let us learn how to fix the issue related to Installation Wizard Hang Forever.
SQL SERVER – Unable to Start SQL Server Agent. Error – Driver’s SQLAllocHandle on SQL_HANDLE_ENV failed
If someone tells me any situation, the first question which I always ask is “What is the error message?”. Now to get the right error message, it is important to look at the right log file. In this blog, we would learn about SQL Server Agent startup issue.
SQL SERVER – Unable to Start Jobs – Error: Enumerate Target Servers Failed for Job
They showed me below error when they were trying to run a job. Let us see how we can fix the error Enumerate Target Servers Failed for Job.
How to Get VLF Count and Size in SQL Server? – Interview Question of the Week #161
Question: How to Get VLF Count and Size Information in SQL Server?
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’