Recently I published a blog about new DMV in SQL Server 2017 called dm_os_enumerate_fixed_drives. While doing that I found another new DMF (Dynamic Management Function) sys.dm_os_file_exists.
One of my clients sent email to know my quick suggestion on one of the error messages. Let us learn how to fix error related to worker thread.
Cannot create worker thread.
BACKUP LOG is terminating abnormally.
Today, I complete 11 years of daily blogging on SQL Authority. I have so far blogged 4200 blog posts on this blog. 11 years have about 4015 days and it seems that I have written over 1 blog posts every single day.
First, let me clarify, the words in the subject of this blog are the exact words used by my client and whatever you do and say but “customer is always right!”. Here is the complete story where we faced issue related to AlwaysOn Replica.