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.

LEAVE A REPLY

Please enter your comment!
Please enter your name here