Hello Christian, If you continue to have this issue, please open a PMR. IBM Support can gather a trace to help pinpoint the problem. HRESULT: 0x80004002 could point to a problem with Windows COM.
Thanks, Del ---------------------------------------------------- "ADSM: Dist Stor Manager" <[email protected]> wrote on 09/27/2011 04:19:26 AM: >> From: Christian Svensson <[email protected]> >> To: [email protected] >> Date: 09/27/2011 04:43 AM >> Subject: TDP SQL reports back ACO5422E >> Sent by: "ADSM: Dist Stor Manager" <[email protected]> >> >> Hi, >> I was hope to find some light here at the forum. >> I have a Windows Server 2003 SP2 with a MS SQL Server 2005 >> Enterprise installed. >> I have installed TSM BA Client 6.2.3.0 and TSM for MSSQL 5.5.5.1 >> and the TSM Server version is 6.2.3.0 >> >> But when I try to run a backup of our MS SQL Server via GUI does a >> got a ! sign on a couple of databases (only 5 of 50 db). >> When I try to backup does databases I got an error "ACO5422E >> Recived the following from the MS SQL Server: Specified cast is not >> valid. (HRRESULT: 0x80004002)" >> But when I try to backup the databases that doesn't have any marks >> on them it works OK. >> >> I have look around on the web and found following artical but none >> of them working for us. >> >> http://adsm.org/forum/showthread.php?24035-Some-database-of-MS-SQL- >> Server-can-t-be-backed-up-using-TDP-for-database >> >> http://adsm.org/forum/showthread.php?23467-How-can-I-exclude-a- >> single-database-from-a-TDP-MSSQL-backup >> >> We have also try to create a dedicated backup account in SQL that >> has full access to everything but that has the same issue if I try >> to use "Integrated" account option in TSM for DB. >> >> I have also involved some DBAs and they can dump the database to a >> flat file without any issue. I have also ask them to compare the >> databases that works and not working. But I haven't heard anything back yet. >> >> Thanks in advanced for your help and suggestions that maybe solve this issue.
