I have found that "Error Code: 0xc00408d4" is when someone has added a database but not updated the config of the SQL master. Then just run the SMSQL config wizard and re run the backup.
Bren
Re: Snapmanager for SQL issue (error codes:0xc00408d4,0x80770004,0xc0040837) job failed