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 Install Service Pack in Cluster – There was an Error to Lookup Cluster Resource Types
A service pack install in a cluster failed with: There was an error to lookup cluster resource types. Detail.txt pointed to the cause. 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 – Script to Audit Login and Role Member Change
A script to audit login and role member changes in SQL Server, tested end to end, including the failed attempts most people never think to capture.
SQL SERVER – Msg 3136, Level 16 – This Differential Backup Cannot be Restored Because the Database has not Been Restored to the Correct Earlier State
I was trying to teach copy-only backups to my students and encountered below error related to differential backup.
SQL SERVER – Msg 3101, Level 16 – Exclusive Access Could not be Obtained Because the Database is in Use
RESTORE failed with Msg 3101: exclusive access could not be obtained because the database is in use. How to find who is connected and your options to fix it.
SQL SERVER – Management Studio Missing – SSMS 2014 not Installed with SQL Server 2014
SSMS 2014 not installed after a SQL Server 2014 setup? The Management Tools feature was never selected. Here is how the discovery report showed it.