ADSM-L

[ADSM-L] TDP SQL Backup error

2009-09-25 13:22:19
Subject: [ADSM-L] TDP SQL Backup error
From: Bill Boyer <bjdboyer AT VERIZON DOT NET>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Fri, 25 Sep 2009 13:19:44 -0400
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

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