Operation failed on virtual machine with error code UserErrorGenericSQLUserCorrectableFault. SQL ErrorNumber: 41070

Like me if you encounter this error while trying to backup SQL server 2017 database on Azure, then there are two possible reasons for this.

I will underline the reasons and also provide the fix

  1. You are using SQL server 2017 and are running CU15, then this error is bound to come every time you try to backup as this is a bug in CU15 and was corrected in a KB pushed later by Micorosft or other next course would be to update to latest CU which right now is CU19
  2. Even though you are on latest CU but are still encountering this error then next course of action would be check your backup preference for the AG group and mark your preference as Either primary or Secondary instead of any replica and Voila you are back in the game and backup sets are working wonderfully again.

Let me know in comments if you think there are other ways to fix this error

SQL Script to find disk space on the server including mount point space

DBA’s are faced with this issue most of the time where they have to get disk space details on a server but the server has mount points configured and xp_fixeddrives doesn’t give you full information.

In such cases I use below script to get free space on the servers including mount point space as well, This script has been modified to give output in below format

Read More »

Change the Default installation path for SQL Server management Studio using Command Prompt

I have earlier written a blog post on how to change default installation path for SQL Server Management studio using PowerShell and registry editor here.
Since then I have tried different things and here I am again with a new way to install SQL Server management Studio from command line to an user desired path.

Read More »

Setting up a SQL Server Lab on your laptop using Hyper-V

Setting a Lab in this day and age is like re-inventing the wheel,  with Cloud at our disposal and plethora of virtual Labs available. Both Azure and AWS offers free credits up to tune of $150/mo or $100/mo to test their products, (MSDN subscription, AWS free credits , other offers) but  sometimes your want of building  from ground up takes control and you jump in without giving a second thought

Read More »