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 – FIX : Error: 3456, Severity: 21 – Could not redo log record (xx:xx:xx), for transaction ID (x:xx), on page (x:xx), database ‘master’
Could not redo log record in master, error 3456, and SQL Server would not start. How we rebuilt and recovered, and the backup that makes it simple.
SQL SERVER – How to Install SSMS From Command Line? Error: The Specified Value for Setting ‘MEDIALAYOUT’ is Invalid.
How to install SSMS from command line? A client’s silent install failed: the specified value for setting MEDIALAYOUT is invalid. Here is the fix.
SQL SERVER – xp_logininfo – Msg 15404: Could not obtain information about Windows NT group/user, error code 0x2147
xp_logininfo failed with Msg 15404 for some users, yet worked for the same user in another domain. Here is what to check to find the difference.
SQL SERVER – Unable to Change “Shared Feature Directory” Under Feature Selection
SQL Server 2014 setup would not let a reader change the Shared Feature Directory: the textbox and browse button were greyed out. The cause and the fix.
SQL SERVER- Error: 18204, Severity: 16 – Backup Failure – Operating System Error 1240 (The Account is not Authorized to Log in From This Station)
A client’s backups to a file share failed at random with error 18204 and OS error 1240. The error message pointed to the real cause of this Backup Failure.
SQL SERVER – Configuration Manager – Cannot Connect to WMI Provider. You Do Not Have Permission or The Server is Unreachable
SQL Server Configuration Manager said: cannot connect to WMI provider, you do not have permission or the server is unreachable. Here is the fix.