Veeam Backup Warning - SQL VSS Writer is missing: databases will be backed up in crash-consistent state

Problem:


When Veeam backup job is running for a SQL server VM and the "application aware processing" is activated on the job Veeam is not capable of using the VSS Writers to backup the databases. Instead, Veeam will proceed with a full backup. The disadvantage is when you need to restore backups in crash-consistent state, you won't be able to recover just the application items (databases, mailboxes, AD objects, etc...), you'll have to do a full restore or just OS files but no application objects recovers.

Notes:

Veeam even has a KB article for the issue. https://www.veeam.com/kb2095

Most of the time, it looks like it's a database naming issue. If your database names contains spaces in them, Veeam is not able to use the SQL VSS Writers.

I strongly suggest that you go trough that article before trying the solution found here. However, in my case, none of the solutions worked from veeam's article.

Solution:

I had to login to my SQL server and under services, change the "SQL Server VSS Writer" service logon account to a domain user account instead of "Local System" account.

 Once you do this, your next backup will be processed properley with the application aware processing.


Location: Montreal, QC, Canada

Comments

Post a Comment

Popular posts from this blog

System.Messaging.MessageQueueException (0x80004005): A workgroup installation computer does not support the operation (Public Queue create issue)

This is a weird issue that I don't fully understand why it would happen. But the symptoms are very persistent as we're able to reproduce these behavior easily. Issue: The MSMQ (Microsoft Message Queuing) fails to create Public Queues and throws  "the System.Messaging.MessageQueueException (0x80004005): A workgroup installation computer does not support the operation" exception.
Read more

Veeam Backup Error : Failed to prepare guest for hot backup. Error: VSSControl

Image
Problem Description; I had this issue on one of my backup jobs recently and I was able to fix the issue with the solution explained below. After a quick google search, I realized that I'm not the only one and neither you are :) Full Error Description; Failed to prepare guest for hot backup. Error: VSSControl: Failed to prepare guest for freeze, wait tim eout 9 00 sec Error: VSSControl: Failed to prepare guest for freeze, wait timeout 900 sec
Read more

warning: Win32API is deprecated after Ruby 1.9.1; use fiddle directly instead - Chef Development Kit Update

Today, I needed to do some tests with a newer version of the Chef Client and test my cookbooks. To version 14.12.9-1 to be precise. I also upgraded my ChefDK on my workstation to the 4.2.0 version. I believe that upgrades Ruby version as well and now I have ruby version 2.6.3p62 Right after the upgrade, I tried with a basic knife node list command to see if I needed to reboot or anything was broke... Everything seems to be working fine, except I get this annoying "warning" message. As it's just a warning, I don't really care about it as it just seems to annonce something that is deprecated... Problem; You receive "warning: Win32API is deprecated after Ruby 1.9.1; use fiddle directly instead" warning when using ruby or chef knife commands. Solution; You need to comment out that warning message in Ruby lib scripts.
Read more