Hi Gurus
I am geting this error in the log file when i try to schedule /un a log backup in DB13 on SQL2005 ERP6 Win2k3.But my online backup run without any problem.
Jobname: SAP CCMS Log Backup of NTP [20080520173655-2-180000]
Type: TSQL
DB-Name: BTP
For Run: 20080520 18:00:00
Job history information *****************************
Stepname: CCMS-step 1
Command: declare @exeStmt nvarchar(2000) exec btp.sap_backup_databases @dbList=
"BTP",@r3Db="BTP",@bDev="Log Backup",@expDays= 27,@bkupChecksum="N",@j
obName= "SAP CCMS Log Backup of BTP [20080520173655-2-180000]",@bkupTy
pe="L",@nativeBkup="N",@exeDate = "20080520180000",@bkupSim = "N",@for
mat = 0,@init = 0,@bkupDb = "BTP",@unload = 0,@exeStmt = @exeStmt OUTP
UT
Status: (failure)
Message: 2528
Severity: 15
Duration: 0 hours(s) 0 min(s) 1 sec(s)
Last msg: Executed as user: NT AUTHORITY\SYSTEM. Incorrect syntax near the keywo
rd 'WITH'. [SQLSTATE 42000] (Error 156) Incorrect syntax near the key
word 'with'. If this statement is a common table expression or an xmln
amespaces clause, the previous statement must be terminated with a sem
icolon. [SQLSTATE 42000] (Error 319) DBCC execution completed. If DBC
C printed error messages, contact your system administrator. [SQLSTATE
01000] (Error 2528). The step failed.
<----
End of Job Step History -
>
Any ideas will be welcome