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 – Error: 566, Severity: 21 – An Error Occurred While Writing an Audit Trace. SQL Server is Shutting Down
SQL Server shut itself down with error 566: an error occurred while writing an audit trace. Here is what the ERRORLOG showed and how to fix it.
SQL SERVER – SQL Installation fails with error code 0x851A001A – Wait on the Database Engine recovery handle failed
SQL Server setup failed with 0x851A001A: Wait on the Database Engine recovery handle failed. The ERRORLOG showed error 17120. Here is what caused it.
SQL SERVER – Script level upgrade for database ‘master’ failed – There is already an object named ‘DatabaseMailUserRole’ in the database
After patching, script level Upgrade for master failed: there is already an object named ‘DatabaseMailUserRole’. Here is what caused it and how to fix it.
Error 9003: Log Scan Number in master Is Not Valid
Error 9003 on the master database means SQL Server cannot recover master and will not start. The master files were corrupt. We rebuilt the system databases, started the instance in single user mode and restored master from a backup.
SQL SERVER – Unable to bring resource online – Error DoREPLSharedDataUpgrade : Failed to create working directory
SQL Server would not come online in the cluster: DoREPLSharedDataUpgrade, Failed to create working directory. The cluster log showed why. Here is the fix.
SQL SERVER Management Studio – Taking DB Offline Made Easier
A train ride with my family got me looking at familiar things with fresh eyes, like how SSMS now makes taking a database Offline easier. Here is how.