A client moved all databases from C to E with ALTER DATABASE, but master kept its old path. Here is the right way to migrate master database files.
SQL SERVER – MSDB Database Uncontrolled Growth Due to Queue_messages. How to Clear All Messages From a Queue?
A client’s MSDB database had grown huge, and queue_messages tables were eating the space. Here is how to find them and clear all messages from a queue.
SQL SERVER – Msg 3168, Level 16 – The Backup of the System Database on the Device Cannot be Restored Because it was Created by a Different Version of the Server
In the recent past, I have written a blog about Ransomware. Here is the link. system database – How to Protect Your Database from Ransomware?
SQL SERVER – Master Database in Single User Mode – A Serious Issue
A client found the master database in single user mode, yet everything worked and switching back to MULTI_USER failed with Msg 5058. Here is the story.
SQL SERVER – Script Upgrade Failure – RsFxFt.Dll::RsFxMgmtInitialize failed: Error 0x80070002
A script upgrade failure left SQL Server down with RsFxFt.Dll error 0x80070002 and error 5597. Tested on SQL Server 2025: the FILESTREAM cause.
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 – Error 17113, Severity: 16 – Error Occurred While Opening File ‘master.mdf’ to Obtain Configuration Information at Startup
I broke my own SQL Server by editing startup parameters. Here is how the ERRORLOG helped me fix error 17113, error opening master.mdf at startup.