SSMS install error 0x80070652 says setup is blocked due to another install currently running. Here is what fixed it for me.
SQL SERVER – Always On Listener Creation Failure – Enabling Object ProdListener Failed With Error 5
I have written a few blogs where I explained a few issues about the failure of listener creation failure in a cluster. Let us learn about it.
Additional Logging for SQL Server Agent: Three Methods
Additional logging for SQL Server Agent means raising the Agent error log level, so the Agent writes more lines about its own work. This post reads the current level, changes it with T-SQL and restores it in the same script, and shows the Management Studio and registry routes.
SQL SERVER – Always On Listener Failure – Provisioning Computer Object Failed With Error 5
I have written a few blogs on issues about the failure of listener creation in the cluster. In this blog, we will explore listener creation failure.
SqlServerWriter Missing in vssadmin: Causes and Fixes
SqlServerWriter missing from the vssadmin output means a backup tool that relies on VSS cannot back up SQL Server. This post checks the three causes: a space at the end of a database name, a login without sysadmin rights, and a stopped writer service. It tests the name check with a demo database.
Agent Service Missing in Configuration Manager: The Fix
An Agent service missing in Configuration Manager can come from a wrong program path. This post compares the service lists, reads the Agent path with T-SQL, checks that the file exists, and explains how to repair the path.
SQL SERVER – Event ID 7000 – The System Cannot Find the File Specified
This blog is from one that came from a DBA from one of my consulting engagements. Let us learn how to fix event id 7000 error.