My instance took unusually long to come up, and the ERRORLOG showed ‘Starting up database’ many times for the same database. Here is why that happens.
SQL SERVER – FIX Error 18456, Severity: 14, State: 6. Login failed for user
A reader hit Error 18456, Severity: 14, State: 6 while logging in. Here is what state 6 means and how to fix this login failed error.
SQL SERVER – FIX Error 18456, Severity: 14, State: 58. Login failed for user
Login failed for user with state 58? Newer SQL Server versions give better details in the ERRORLOG. Here is how to FIX Error 18456 when you see this state.
SQL SERVER – Huge Transaction Log (LDF) for Database in Availability Group
A reader’s database in an AlwaysOn availability group grew a Huge Transaction Log of 230 GB with error 9002, AVAILABILITY_REPLICA. Here is what to check.
SQL SERVER – Install Error – The /UIMode setting cannot be used in conjunction with /Q or /QS
Installing SQL Server from a configuration file failed with: The /UIMode setting cannot be used in conjunction with /Q or /QS. Here is the quick fix.
Interview Question of the Week #056 – How to fix Installation Failure – Rule “Setup account privileges” Failed in SQL Server
An interview practical: fix a SQL Server installation failure when the rule Setup account privileges failed. Here is the answer.
SQL SERVER – Script level upgrade for database ‘master’ failed because upgrade step ‘sqlagent100_msdb_upgrade.sql’
After a patch, my SQL Server would not start because upgrade step ‘sqlagent100_msdb_upgrade.sql’ failed with error 537. Here is how I fixed it.