SQL Error Messages Archives - Page 3 of 114 - SQL Authority with Pinal Dave

SQL SERVER – Removing Additional Transactional Log Files

April 13, 2020

While working on Comprehensive Database Performance Health Check about additional transactional log files and today I got to follow up via email.

April 12, 2020

Question: How to Solve Error When Transaction Log Gets Full?

Answer: This was a question I was asked in the recent Health Check.

April 8, 2020

I personally prefer to use DMVs and DMFs but for the visualization easiness client preferred Activity Monitor which was Freezing suddenly.

March 31, 2020

Let us learn how to solve Configuration Manager – Cannot Connect to WMI Provider. You Do Not Have Permission or The Server is Unreachable.

March 30, 2020

My clients enabled query store features to perform some troubleshooting which was a cause of unable to disable Query Store for Always On Database.

March 27, 2020

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

March 25, 2020

Let us fix today – Msg 3254 The volume on device is empty. Followed by Msg 3013 – RESTORE DATABASE is terminating abnormally.