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.
SQL SERVER – The Log Scan Number Passed to Log Scan in Database ‘master’ is not Valid
Let us learn in this blog how to fix The Log Scan Number Passed to Log Scan in Database ‘master’ is not Valid. Let us learn in this blog post.
SQL SERVER – How to Download Microsoft OLE DB Provider for Oracle (MSDAORA) for 64 bit?
MSDAORA, the Microsoft OLE DB Provider for Oracle, has no 64-bit version. Here is what to use instead for an Oracle linked server on 64-bit SQL Server.
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.
SQL SERVER – Rule “Windows Management Instrumentation (WMI) Service” failed
Upgrading a two-node cluster from SQL 2008 R2 to 2014, the rule ‘Windows Management Instrumentation (WMI) Service’ failed. Here is how we fixed it.