ADSM-L

Re: SQL backup error.

2001-03-06 09:26:47
Subject: Re: SQL backup error.
From: Del Hoobler <hoobler AT US.IBM DOT COM>
Date: Tue, 6 Mar 2001 09:27:34 -0500
Bo,

This is most likely APAR IC26111.  There is a fix for this.
This is FIXTEST Version 1.1.2.01.  It includes the following fix:

 IC26111

   If a SQL Server 7.0 database is at compatibility level 60 or 65, an
   attempt to backup the database or its transaction log would result
   in the DB-Lib message "Incorrect syntax near the keyword
   'database'" and the backup would fail.  This no longer occurs.
   Databases at any compatibility level can now be backed up
   successfully.

You can download it from the following web site:


ftp://ftp.software.ibm.com/storage/tivoli-storage-management/patches/agents/ntsql/1.1.2/


Thanks,

Del

----------------------------------------------------
Del Hoobler
Del Hoobler
IBM Corporation
hoobler AT us.ibm DOT com


Bo Nielsen <Bo_Nielsen AT FDB DOT DK>@VM.MARIST.EDU> on 03/06/2001 09:01:18 AM

Please respond to "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>

Sent by:  "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>


To:   ADSM-L AT VM.MARIST DOT EDU
cc:
Subject:  SQL backup error.



Hi All,

I try to backup a MSSQL database,
but receive the following error:

 DB-LIB message: Incorrect syntax near the keyword 'database'.
 TSM status: ANS1303E (RC3)    Client ended transaction

Maybe the problem is that there is a '_' underscore i the DB name.???

The TDP agent is version 1.1.2
TSM server 4.1.20

Regards,

Bo Nielsen.

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