Hi Bill,
I suggest calling IBM support.
In this case, it is strange that the internal backup tool is working
but Data Protection for SQL is failing. The SQL Server is
telling Data Protection for SQL:
"BACKUP detected corruption in the database log."
I think this is a SQL Server problem of some sort.
IBM support will be able to examine the traces to find out what is going
on.
Thanks,
Del
----------------------------------------------------
"ADSM: Dist Stor Manager" <ADSM-L@VM.MARIST.EDU> wrote on 09/25/2009
01:19:44 PM:
> [image removed]
>
> TDP SQL Backup error
>
> Bill Boyer
>
> to:
>
> ADSM-L
>
> 09/25/2009 01:20 PM
>
> Sent by:
>
> "ADSM: Dist Stor Manager" <ADSM-L@VM.MARIST.EDU>
>
> Please respond to "ADSM: Dist Stor Manager"
>
> Doing the FULL backup of this database on a SQL Server 2005 on
Windows2003
> using the TDP SQL agent 5.2.1.6, TSM client 5.5.0.3 and TSM server
5.5.3.0
> on AIX. we get the following SQL error being returned. The database is
up
> and running and the application has no complaints. The log backups run
> hourly and they are successful. The admin of the application (we don't
have
> any DBA's) has been able to do a SQL backup to disk with no errors. Been
> doing searches but we must not be using the right keywords as we haven't
> found anything really applicable. Can anyone give us some insight or
help in
> figuring this error out? The last full backup we were able to get was
3-days
> ago. Since then nothing but logs.
>
>
>
>
>
> 09/24/2009 00:12:58 ACO5436E A failure occurred on stripe number (0), rc
=
> 428
>
> 09/24/2009 00:12:58 ACO5407E The SQL server aborted the operation.
>
> 09/24/2009 00:12:59 Backup of scenter failed.
>
> 09/24/2009 00:12:59 ACO5422E Received the following from the MS SQL
server:
>
> 09/24/2009 00:12:59 [Microsoft][ODBC SQL Server Driver][SQL
Server]BACKUP
> detected corruption in the database log. Check the errorlog for more
> information.
>
> 09/24/2009 00:12:59 [Microsoft][ODBC SQL Server Driver][SQL Server]A
> nonrecoverable I/O error occurred on file "TDPSQL-00000DA0-0000:"
995(The
> I/O operation has been aborted because of either a thread exit or an
> application request.).
>
> 09/24/2009 00:12:59 [Microsoft][ODBC SQL Server Driver][SQL
Server]BACKUP
> DATABASE is terminating abnormally. Microsoft SQL-DMO (ODBC SQLState:
42000)
> (HRESULT:0x80040be9)
>
>
>
>
>
> TIA!
>
>
>
> Bill Boyer
>
> "He who laughs last probably made a back-up." Murphy's law of computing
