ADSM-L

TDP for SQL errors

2003-01-22 02:24:42
Subject: TDP for SQL errors
From: Maria Ilieva <m.ilieva AT MOBILTEL DOT BG>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Wed, 22 Jan 2003 09:21:12 +0200
Hi,
I have some problems with the backup of MSSQL databases and I need your help.

TSM 5.1.1.6 Server on AIX 4.3
TSM 5.1.7 Client
TDP for MSSQL 5.1.5 

Backup fails most of the time for some databases (they are not the same every 
time) and sometimes completes without errors.

I'm receiving the folowing errors:

In the Windows event log:

20.1.2003 21:00:25 MSSQLSERVER Error (2) 17055 NT AUTHORITY\SYSTEM NAUTILUSA 
18210 :
BackupVirtualDeviceSet::SetBufferParms: Request large buffers failure on backup 
device 'TDPSQL-00000AF0-0000'. Operating system error -2147024888(error not 
found).
 
20.1.2003 21:00:23 MSSQLSERVER Error (2) 17055 NT AUTHORITY\SYSTEM NAUTILUSA 
18210 :
BackupVirtualDeviceFile::RequestDurableMedia: Flush failure on backup device 
'TDPSQL-00000AF0-0000'. Operating system error 995(error not found).
 
20.1.2003 21:00:23 MSSQLSERVER Error (6) 17055 NT AUTHORITY\SYSTEM NAUTILUSA 
3041 :
BACKUP failed to complete the command USE master BACKUP LOG [FEIBank] TO 
VIRTUAL_DEVICE=N'TDPSQL-00000AF0-0000' WITH BLOCKSIZE=512, 
MAXTRANSFERSIZE=4194304, NO_TRUNCATE, NAME=N'log', 
DESCRIPTION=N'TDPSQL-00000AF0-0000 (TDP MS SQL V2)'

In the TDP schedule log:
01/22/2003 09:00:38 ACO5422E Received the following from the MS SQL server:
01/22/2003 09:00:38 [Microsoft][ODBC SQL Server Driver][SQL Server]BACKUP LOG 
is terminating abnormally. Microsoft SQL-DMO (ODBC SQLState: 42000) 
(HRESULT:0x80040bc5)
01/22/2003 09:00:39 ACO5436E A failure occurred on stripe number (0), rc = 428
01/22/2003 09:00:39 ACO5407E The SQL server aborted the operation.
01/22/2003 09:00:39 Backup of Virgo failed.
01/22/2003 09:00:39 ACO5422E Received the following from the MS SQL server:
01/22/2003 09:00:39 [Microsoft][ODBC SQL Server Driver][SQL Server]BACKUP LOG 
is terminating abnormally. Microsoft SQL-DMO (ODBC SQLState: 42000) 
(HRESULT:0x80040bc5)
01/22/2003 09:00:40 ACO5436E A failure occurred on stripe number (0), rc = 428
01/22/2003 09:00:40 ACO5407E The SQL server aborted the operation.
01/22/2003 09:00:41 Backup of WaitImport failed.
and so on...

Any help is appreciated

Maria Ilieva

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