Veeam SQL Backup Unable to release guest. Error: VSSControl: Failed to freeze guest, wait timeout
A client of mine recently built a new SQL server and added the SQL server to the Veeam Backup job. When running the backup the new SQL server would fail when backing up with the following error.
Error: VSSControl: Failed to freeze guest, wait timeout
The client was running version 6.5 and was eligible for an upgrade to 7 so I carried out the upgrade of veeam 6.5 to 7. Unfortunately this did not resolve the issue. On the SQL server I wanted to check the status of the SQL VSS Writer which Veeam uses to freeze the DB, to do so I issued this command at command line on the SQL server.
Vssadmin list writers
This showed me that the SQL Writer was in a timed out status. Now im not an SQL guru bu any stretch of the imagination, however after doing a bit of research I found that sometimes when the account you use in Veeam does not have access to the SQL instance then you may get this issue.
To resolve I opened up Services.msc on the SQL server, located the SQL Server VSS Writer and set the log on account to be the local admin account on the SQL server.
I then restarted the service and ran.
net stop vss net start vss
I then went back to my Veeam server and ran the SQL job again. Success. Thanks to my colleague Stephen Morrison for help getting through this issue.
I’m impressed! You’ve managed the almost imosspible.
I was having an issue and it looks like this works but now on the SQL server there are login failure errors for .\administrator when the job is running. why? and are these backups actually valid?