Skip to Content
Former Member
May 27, 2008 at 01:29 PM

Log Backup error


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


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