FAQ: SQL backup fails with incomplete backup received from client

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

http://social.technet.microsoft.com/Forums/en-US/dpmsqlbackup/thread/ffaea3d1-2ecb-45f6-89c9-1fee249ccac6

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

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Contact us