Question: How to Solve Error When Transaction Log Gets Full?
Answer: This was a question I was asked in the recent Health Check.
SQL SERVER – Fixing Freezing Activity Monitor
I personally prefer to use DMVs and DMFs but for the visualization easiness client preferred Activity Monitor which was Freezing suddenly.
SQL SERVER – Fix: Configuration Manager- Cannot Connect to WMI Provider. You Do Not Have Permission or The Server is Unreachable
Let us learn how to solve Configuration Manager – Cannot Connect to WMI Provider. You Do Not Have Permission or The Server is Unreachable.
SQL SERVER – Unable to Disable Query Store for Always On Database
My clients enabled query store features to perform some troubleshooting which was a cause of unable to disable Query Store for Always On Database.
SQL SERVER – Upgrade Failure – There are No More Endpoints Available From the Endpoint Mapper
When my client was trying to patch the other node, it failed with an error – There are No More Endpoints Available From The Endpoint Mapper
SQL SERVER – Msg 3254 – The Volume on Device Path\File is Empty. RESTORE DATABASE is Terminating Abnormally
Let us fix today – Msg 3254 The volume on device
SQL SERVER – Error 9002: The Transaction Log for Database ‘SQLAuthority’ is Full Due to ‘REPLICATION’
In this blog, I would explain the cause and fix of error: The transaction tog for database ‘SQLAuthority’ is full due to ‘REPLICATION’.