Maria

I have had a number of such problems and found the key to resolving them
usually lies in the operating system error number - in your case
-2147024888.

Check the SQL Server VDI.LOG to confirm, but like Eric says -2147024888
indicates "Not enough storage space is available to process the command".
Other possible numbers are -2147467262 (No such interface supported) and
-2147221163 (Interface not registered) - in either case refer to Microsoft
knowledge base article id Q323602.

In any case, the problem usually lies with the SQL Server Virtual Device
Interface (VDI) rather than the TDP config. When we experienced "not enough
storage space..." errors during TDP backups, it was down to fragmentation
of the SQL Server MemToLeave area (see my posting last October -
http://msgs.adsm.org/cgi-bin/get/adsm0210/1307.html).

By increasing the size of the MemToLeave area using the SQL Server '-g'
startup switch, we alleviated all the problems. The -g switch was
introduced in SQL Server 7.0 SP2 - see Microsoft knowledge base article id
Q254555.

Neil Schofield
Yorkshire Water Services Ltd.



-----Original Message-----
From: Maria Ilieva [mailto:m.ilieva AT MOBILTEL DOT BG]
Sent: Wednesday,  January 22, 2003 08:21
To: ADSM-L AT VM.MARIST DOT EDU
Subject: TDP for SQL errors


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


**********************************************************************
For information, services and offers, please visit our web site:
http://www.klm.com. This e-mail and any attachment may contain confidential
and privileged material intended for the addressee only. If you are not the
addressee, you are notified that no part of the e-mail or any attachment
may be disclosed, copied or distributed, and that any other action related
to this e-mail or attachment is strictly prohibited, and may be unlawful.
If you have received this e-mail by error, please notify the sender
immediately by return e-mail, and delete this message. Koninklijke
Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or its employees
shall not be liable for the incorrect or incomplete transmission of this
e-mail or any attachments, nor responsible for any delay in receipt.
**********************************************************************






Visit our web site to find out about our award winning
Cool Schools community campaign at
http://www.yorkshirewater.com/yorkshirewater/schools.html
The information in this e-mail is confidential and may also be legally
privileged. The contents are intended for recipient only and are subject 
to the legal notice available at http://www.keldagroup.com/email.htm
Yorkshire Water Services Limited
Registered Office Western House Halifax Road Bradford BD6 2SZ
Registered in England and Wales No 2366682