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 – Event ID 107- Report Server Windows Service (MSSQLSERVER) cannot connect to the report server database.
Event ID 107 says the Report Server Windows service cannot connect to the report server database. Here is how I fixed it.
SQL SERVER – Network Name resource fails to come online in a Windows Server 2008 R2 Failover Cluster
After adding a new disk, a client’s cluster Network Name resource would not come online in a Windows Server 2008 R2 Failover Cluster. Here is what we found.
SQL SERVER – Drive Space Full Due to MDMP Files
A client’s C drive kept filling up, and the transaction log was not to blame. SQL dump files were. Here is what caused this Drive Space Full issue.