Hi Maria! The error -2147024888 you are seeing means "Not enough storage is available to process this command" Read the following message (and response from IBM) for a possible solution: http://msgs.adsm.org/cgi-bin/get/adsm0205/206.html Good luck! Kindest regards, Eric van Loon KLM Royal Dutch Airlines
-----Original Message----- From: Maria Ilieva [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 22, 2003 08:21 To: [EMAIL PROTECTED] 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. **********************************************************************
