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.
SQL SERVER – RETAINDAYS Does Not Delete Backup After x Days
Just the other day one of my customers asked me that they are facing a situation where they have specified in their backup script RETAINDAYS option but it is actually not deleting their older database backups.Â
SQL SERVER – 5 Don’ts When Database Corruption is Detected
Here is an email I received about database corruption and that has lead me to write this quick blog post about database corruption.Â
SQL SERVER – How to Delete a Single Table From SQL Server Backup File (.bak)
Question:Â How to Delete a Single Table From SQL Server Backup File (.bak)?
SQL SERVER – How to Enable Backup Compression On by Default
In this blog post we will discuss how to Enable Backup Compression on by default.
SQL SERVER – What Are Ghost Records and How to Clean Them Up?
What are Ghost Records and How to Clean Them Up?
I loved this question when I received it last week in my SQL Server Performance Tuning Practical Workshop.
SQL SERVER – 7 Important Things to Remember While Taking Effective Backup
In this blog post we will discuss 10 things to remember while taking effective backup for SQL Server.Â