SUMMARY
SQL backup fails with incomplete backup received from client
ISSUE
Windows agent SQL backups fail with the following message in the RRC: "incomplete backup recieved from client" when attempting a VSS SQL DB backup.
a message like the following shows up in the WBPS log on the client:
May 25 09:58:29 : Unitrends SQL Server agent failed verify component '{A65FAA63-5EA8-4EBC-9DBD-A0C4DB26912A}:\DB2008\adminotg65' was not found in the writer components list! Aborting backup ...
May 25 09:58:29 : - Please check the definitions of the component name in profile file: 'BackupTarget' and 'RestoreTarget'.
May 25 09:58:29 : Unable to perform a backup of database 'adminotg65', instance 'DB2008': The problem occurred while trying to connect SQL Server VSS Writer. Please check that the SQL Server VSS Writer is installed and running on the clientMay 25 09:58:29 :
May 25 09:58:29 : If you have any databases with a trailing space at the end of database name, it could cause that SQL Server VSS Writer doesn't list any databases and not be present on your system
May 25 09:58:29 : Unitrends SQL Server agent failed to get backup volume list.
RESOLUTION
Remove or rename the database with a trailing space in its name
Third-Party Sources
CAUSE
One or more datbases, but not necessarilly the particular database you're backing up, ends with a SPACE.
NOTES
For more detailed information on backup failures and performance issues see Unitrends KB 5062 - Backup Failures and Performance Issues