ADSM-L

Re: SQL BACKUP FAILS

2006-02-24 09:05:56
Subject: Re: SQL BACKUP FAILS
From: Del Hoobler <hoobler AT US.IBM DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Fri, 24 Feb 2006 09:04:58 -0500
Thando,

This is not enough information to troubleshoot this problem.
I suspect some type of configuration problem with
Data Protection for SQL.

What is the result of this command?
    TDPSQL QUERY TSM
Does it return valid information?

If so, can you try just using one stripe for backup?
   TDPSQLC BACKUP master FULL /STRIPES=1
Does this work?

Thanks,

Del

----------------------------------------------------

Del Hoobler
Tivoli Storage Manager Development
IBM Corporation



"ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU> wrote on 02/24/2006
07:01:50 AM:

> Hi TSMmers
>
> I`m trying tobackup SQL database and I`m getting the following errors:
> TDP.SQL
> CO5436E A failure occurred on stripe number (0), rc = 418
> 02/23/2006 11:36:44 ANS1017E (RC-50)  Session rejected: TCP/IP
connection
> failure
> 02/23/2006 11:36:45 Backup of BAMArchive failed.
> 02/23/2006 11:36:45 ANS1017E (RC-50)  Session rejected: TCP/IP
connection
> failure
> 02/23/2006 11:36:54 *** Request being sent to cancel the current
command.
> 02/23/2006 11:36:55 ACO5436E A failure occurred on stripe number (2), rc
=
> 419
> 02/23/2006 11:36:55 ACO0003S An internal processing error has occurred.
> 02/23/2006 11:36:55 Backup of BizTalkMgmtDb failed.
> 02/23/2006 11:36:55 ACO0003S An internal processing error has occurred.
> 02/23/2006 11:36:55 Total SQL backups selected:               18
> 02/23/2006 11:36:55 Total SQL backups attempted:              18
> 02/23/2006 11:36:55 Total SQL backups completed:              2
> 02/23/2006 11:36:55 Total SQL backups excluded:               0
>
> The normal system backup wroks fine but the sql backup fails with the
> above error.
>
> I`m running TSM Version 5, Release 2, Level 2.0 on AIX 5200-07
> The Cient is Win 2003 running SQL 2000
>
> Any pointers will come in handy @ this point.
>
>
> TIA
>
>
> Kind Regards
> Thando Ndaba

<Prev in Thread] Current Thread [Next in Thread>