Backup of SQL Database ****** will not be attempted.
ACO5422E Received the following from the MS SQL server:
Specified cast is not valid. (HRESULT:0x80004002)
If you get this error,you will do some changes in the tdp.cfg file.Under the page you can see IBM APAR.So you can add line your *cfg file.
1. set QUERYOPTimization to 0 in the Data Protection for SQL Configuration file (tdpsql.cfg is the default) or 2. In the SQL Sever associated with the affected databases, set the AUTO_CLOSE property to False.
Tivoli Storage Manager for Databases: Data Protection for SQL backup can fail with the following error: 10/26/2011 03:07:06 Backup of SQL Database pb_master will not be attempted. 10/26/2011 03:07:06 ACO5422E Received the following from the MS SQL server: 10/26/2011 03:07:06 Specified cast is not valid. (HRESULT:0x80004002) 10/26/2011 03:07:06 Total SQL backups selected: 1 10/26/2011 03:07:06 Total SQL backups attempted: 0 10/26/2011 03:07:06 Total SQL backups completed: 0 10/26/2011 03:07:06 Total SQL backups excluded: 0 10/26/2011 03:07:06 Total SQL backups inactivated: 0 10/26/2011 03:07:06 Throughput rate: 0.00 Kb/Sec 10/26/2011 03:07:06 Total bytes transferred: 0 10/26/2011 03:07:06 Elapsed processing time: 0.00 Secs 10/26/2011 03:07:06 ACO0151E Errors occurred while processing the request. The problem exists only if QUERYOPTimization option is set to 1 in Microsoft SQL 2005, and later environments. If queryopt is 0, or Microsoft SQL 2000 is used, then Data Protection for SQL works fine.