Fannizo

This is 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


Davide Fanizzo <davide.fanizzo AT BANCAAKROS DOT IT>@VM.MARIST.EDU> on 
01/31/2001
04:27:40 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:



We run TDP for Microsoft SQL 1.1.2, for the backup of my 3 SQL Server.
Whe i try to backup some database from one SQL server the system give me
this respons:


  Tivoli Storage Manager
  Tivoli Data Protection for Microsoft SQL Server - Version 1, Release 1,
Level 2
  (C) Copyright IBM Corporation 1997, 1999. All rights reserved.

  TSM API Version 3, Release 7, Level 0
  TSM Nodename: bofut

  License file exists and contains valid license data.

  Logging on to the TSM server...

  Logging on to the SQL server...


  Backing up SqlCocoPr...

  Waiting for Sql server...
  TSM Status: ANS1303E (RC3)    Client ended transaction
  SQL Status: DB-LIB message: Incorrect syntax near the keyword 'database'.
my SQL sever is 7.0.699

Fanizzo Davide
System Administrator
Banca Akros S.p.A.
Cell +39 348 8705668