Geoff,
I have seen this message before. Check the Compatibility level of your
database using the sp_dbcmptlevel command. When I saw this problem, I was
using SQL 7.0, but the compatibility level was 6.5. I fixed it by upgrading
to TDP for MS SQL Server v1.1.2 (IP21873).
Rick Smith
Storage Management
State Farm Insurance
(309) 735-3086
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Friday, July 21, 2000 1:09 PM
To: [EMAIL PROTECTED]
Subject: SQL Backups
Has anyone seen this and can tell me what it is? The explanation below is
pretty vague. I've notived this SQL database is not being backed up with the
SQL Client. And when I try to back it up manually this is the error message
I get.
07/21/2000
10:14:30,===================================================================
====
07/21/2000 10:14:38,Backed up - DIRECTORY, type: DB, size: 437163052, actual
bytes: 0, secs: 0.0, Kb/Sec: 0.0, SQL server: CP_ITS_SQL01, TSM server: dsm,
SQL status: DB-LIB message: Incorrect syntax near the keyword 'database'.,
TSM status: ANS1303E (RC3) Client ended transaction
Explanation: The client system ended the operation with the server and ended
the current transaction.
System Action: Processing stopped.
User Response: Restart the session.
Geoff Gill
NT Systems Support Engineer
Computer Systems Group
E-Mail: [EMAIL PROTECTED]
Phone: (858) 826-4062
Pager: (888) 997-9614
