ADSM-L

Re: [ADSM-L] TDP SQL Backup error

2009-09-25 13:31:29
Subject: Re: [ADSM-L] TDP SQL Backup error
From: David McClelland <tsm AT NETWORKC.CO DOT UK>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Fri, 25 Sep 2009 18:30:31 +0100
Does anything else get logged into the SQL Server error log Bill?

A quick search on the "rc = 428" bit brings up something that might be worth
looking into: http://www.mail-archive.com/adsm-l AT vm.marist DOT 
edu/msg35535.html

/David Mc
London, UK



-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Bill Boyer
Sent: 25 September 2009 18:20
To: ADSM-L AT VM.MARIST DOT EDU
Subject: [ADSM-L] TDP SQL Backup error

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

No virus found in this incoming message.
Checked by AVG - www.avg.com
Version: 8.5.409 / Virus Database: 270.13.112/2392 - Release Date: 09/25/09
05:51:00

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