We are here to help!

Find new ways to use Atera, Ask us anything.

Follow

Error: VSS error 0x800423f4

Solution

'VSS error 0x800423f4' can indicate a few different issues and can appear when:
  1. Your database has SINGLE_USER access and it has been already opened. Make sure no one uses the database during backup or change the access mode. 
  2. Name of the database has leading/trailing spaces or unprintable characters. Fix the database name by removing the unsupported characters.
  3. Microsoft Volume Shadow Copy Service (VSS) and SQL Server VSS Writer Service are not running or unstable. Check system logs and solve the issue.
  4. Lack of worker threads. Try to increase the Max Worker Threads configuration option of MS SQL Server.

Depending on the configuration of a SQL Server, available threads can be used if you create a snapshot backup of many databases at the same time. Microsoft has an article referring to the issue and its workaround:

  • If you are running a 64-bit version of SQL Server, you can consider increasing the Max Worker Threads configuration option
  • If you are running a 32-bit version of SQL Server, check the influence of increasing of Max Worker Threads on server performance
How to configure the Maximum Number of Worker Threads (SQL Server Management Studio):

***** In order to complete the backup successfully you will need to configure 5 Worker Threads for each SQL instance, for example: if you have 10 SQL instances (databases) you will need to configure 50  Worker Threads in the Max Worker Threads option. *****

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request