A SQL Server patch failed while installing the Visual Studio 2010 Shell. The VC10 redist log showed the cause, and here is how I fixed it.
SQL SERVER – Clustered SQL Resource Not Coming Online
Clustered SQL resource stuck in online pending, yet the service started fine from services.msc. The cluster log showed a login failure. Here is the fix.
SQL SERVER – Unable to Add Server Name SQLAUTH-LISTENER to Transport Device NetBt_If4 Status 2 – Windows Cluster
An availability group listener would not come online. The cluster log said unable to add server name to transport device NetBt_If4, status 2.
SQL SERVER – FIX: Error: 913, Severity: 16 – Could Not Find Database ID 3. Database May Not be Activated Yet or May be in Transition – SQL Service
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.
Slow Database Creation in SQL Server: Causes and Fixes
Slow database creation in SQL Server comes down to its files: how big they are, and whether SQL Server must zero every byte. This post checks the three usual suspects, the size of the model database, instant file initialization and the log file, and times each one with a script. It also shows the wait type to look for while a large CREATE DATABASE runs.
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.