BACKUP error

[Former Member]

Hello Gurus,

I am trying to take Differential backup from DB13 T Code but after 5 Sec. it got terminated with this message - "Finished with error" and color become RED.

Please lemme know the solution.

Configuration:

ECC 6.0

SQL Server 2005

Window Server 2003

Enclosed is the Program log.

• SQL Task information ************************

Jobname: SAP CCMS Diff DB Backup of msdb [20090821102149-5-102149]

Stepname: Step1

Type: TSQL

DB-Name: EC6

Command: ec6.sap_backup_diff_databases @dblist="msdb",@r3

db="EC6",@bdev="Backup",@unload=0,@verify=0,@job

name= "SAP CCMS Diff DB Backup of msdb [20090821

102149-5-102149]"

• Task history information *******************

For Run: 20090821 10:21:49

Status: (failure)

Message: 319

Severity: 15

Duration: 0 hours(s) 0 min(s) 0 sec(s)

Last msg: Executed as user: VMSAPECC62\Administrator. DBCC e

xecution completed. If DBCC printed error messages

, contact your system administrator. [SQLSTATE 010

00] (Message 2528) Incorrect syntax near the keyw

ord 'Backup'. [SQLSTATE 42000] (Error 156) Incorr

ect syntax near the keyword 'with'. If this statem

ent is a common table expression or an xmlnamespac

es clause, the previous statement must be terminat

ed with a semicolon. [SQLSTATE 42000] (Error 319).

The step failed.

• Task history information *******************

Thanks

Rhishabh

Edited by: Sap_basis_admin on Aug 21, 2009 7:13 AM

[Former Member · Accepted solution]

This will help you.

[;

[Former Member]

Answered