SQL Server would not start and the ERRORLOG showed Error 913: could not find database ID 3. Database may not be activated yet. Here is the fix.
SQL SERVER – Unable to recycle Errorlog – sp_cycle_errorlog – OS error 1392
On a clustered server the nightly ERRORLOG cycling stopped, and sp_cycle_errorlog failed with OS error 1392. Here is what that means and how we fixed it.
SQL SERVER – The header for file Path is not a valid database file header. The PageAudit property is incorrect
SQL Server would not start: model.mdf did not have a valid database file header and the PageAudit Property was incorrect. How I got it running again.
SQL SERVER – Unable to Recycle ERRORLOG Using sp_cycle_errorlog
A reader could not recycle ERRORLOG files with sp_cycle_errorlog. The ERRORLOG itself showed the reason. Here is what went wrong and how to fix it.
SQL SERVER – Error: 26014, Severity: 16. Unable to Load User Specified Certificate
After a client changed the SQL Server certificate, the service would not start: Error 26014, unable to load User Specified Certificate. Here is how we fixed it.
SQL SERVER – Setup Screen Not Launching While Updating a Patch
Double clicking a SQL Server patch just flashed a window and vanished. SqlSetup.log in the %temp% folder showed why the Setup Screen was not launching.
SQL SERVER – Database Disaster Recovery Process
When a bad change or data loss hits, act fast. The steps of a database Disaster Recovery process, from what to do right after the disaster to getting data back.