Hi Maria,
I have a client that has the same exact problem producing the same error
messages. We are running TSM B/A client 5.1.5.2, TDP for SQL 2.2.1.0
running on TSM server 5.1.6.0 on AIX 4.3.3.
I tried the suggested changes in the ADSM.ORG posting, but they do not work.
The messages are no doubt being generated by SQL server, and I originally
thought it was a memory leak issue, but I am just not sure. I have no other
clients with this problem, but have other clients running the same TSM
agents.
Any other suggestions the group might have are appreciated.
Regards,
Matt Adams
Tivoli Storage Manager Team
Hermitage Site Tech
Deloitte and Touche USA LLP
-----Original Message-----
From: Loon, E.J. van - SPLXM [mailto:Eric-van.Loon AT KLM DOT COM]
Sent: Wednesday, January 22, 2003 6:21 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: TDP for SQL errors
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: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.
**********************************************************************
- This message (including any attachments) contains confidential information
intended for a specific individual and purpose, and is protected by law. -
If you are not the intended recipient, you should delete this message and
are hereby notified that any disclosure, copying, or distribution of this
message, or the taking of any action based on it, is strictly prohibited.
|
