Hi Eric, You didn't give any details about the BUFFERS, BUFFERSIZE, SQLBUFFERS, SQLBUFFERSIZE, or STRIPES that you are using. I would start by setting BUFFERS 3 BUFFERSIZE 1024 SQLBUFFERS 0 SQLBUFFERSIZE 1024 STRIPES 1 to see if that helps at all. If not, I suggest that you place a call with IBM Support. This one may need a trace and help from support to solve.
Thanks, Del ---------------------------------------------------- "ADSM: Dist Stor Manager" <ADSM-L@VM.MARIST.EDU> wrote on 11/27/2007 04:22:28 AM: > Hi TSM-ers! > One of our SQL Server 2005 (running DP for SQL Server 5.3.3.0) the full > backup fails every time. > In the tdpsql.log we see the following messages: > > 11/23/2007 02:26:44 ACO5436E A failure occurred on stripe number (0), rc > = 428 > 11/23/2007 02:26:44 ACO5407E The SQL server aborted the operation. > 11/23/2007 02:26:44 Backup of InTrust_Audit_DB failed. > 11/23/2007 02:26:44 ACO5422E Received the following from the MS SQL > server: > 11/23/2007 02:26:44 [Microsoft][ODBC SQL Server Driver][SQL Server]A > nonrecoverable I/O error occurred on file "TDPSQL-0000026C-0000:" > 995(The I/O operation has been aborted because of either a thread exit > or an application request.). > 11/23/2007 02:26:44 [Microsoft][ODBC SQL Server Driver][SQL > Server]BACKUP DATABASE is terminating abnormally. Microsoft SQL-DMO > (ODBC SQLState: 42000) (HRESULT:0x80040cc7) > > Does anyone know what could be the cause? Google-ing for 0x80040cc7 > returns one hit. Someone posted the exact same error on a forum, but did > not receive a solution... > Thanks in advance for any reply!!! > Kindest regards, > Eric van Loon
