Here are the steps I used to migrate Cluster Storage for a SQL Server 2014 cluster from old IBM disks to new ones: data, log, TempDB, MSDTC and quorum.
SQL SERVER – Installation Wizard Hang Forever – Please Wait on Feature Selection Page
Adding Analysis Services to SQL Server 2014, the Installation Wizard hung on “Please Wait” at feature selection, even after my lunch. Here is what fixed it.
SQL SERVER – Unable to Start SQL Server Agent. Error – Driver’s SQLAllocHandle on SQL_HANDLE_ENV failed
SQL Server Agent would not start, and the log said Driver’s SQLAllocHandle on SQL_HANDLE_ENV failed. Here are the logs I check and the fix I found.
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.
SQL SERVER – Script Level Upgrade for Database ‘master’ Failed Because Upgrade Step ‘sqlagent100_msdb_upgrade.sql’ – Error: 5041: MODIFY FILE Failed
One more cause of the script level upgrade failure for ‘sqlagent100_msdb_upgrade.sql’: Error 5041, MODIFY FILE failed. Here is how I fixed it.
SQL SERVER – Msg 1105 – Could Not Allocate Space for Object Name in Database ‘DB’ Because the ‘PRIMARY’ Filegroup is Full
Msg 1105 says SQL Server could not allocate space for an object because the PRIMARY filegroup is full, even with free disk. Here is how to reproduce and fix it.
SQL SERVER – The Description for Event ID 18456 From Source MSSQLSERVER Cannot be Found
A client’s event log said the description for Event ID 18456 from source MSSQLSERVER cannot be found. Here is what it means and where to see the real error.