ADSM-L

Re: [ADSM-L] DP for SQL Server full backup failure

2007-11-27 06:40:45
Subject: Re: [ADSM-L] DP for SQL Server full backup failure
From: Del Hoobler <hoobler AT US.IBM DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Tue, 27 Nov 2007 06:40:10 -0500
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 AT VM.MARIST DOT 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

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