DBACOCKPIT job backup error

[Former Member]

HEllo All.

I defined at the SQL Server management studio at SERVER OBJECTS -> BACKUP DEVICES a location at another server in order to take backup of the DB at the night.

If i run the backup from the Sql Server managemaent studio the db is backup up correctly.

After i enter to SAP and i run transaction DBACOCKPIT and i choose a new job to be executed immidietely to a fully backup of my database and i have the following error:

• SQL Job information ******************************

Jobname: SAP CCMS Log Backup of GDW [20110616143641-4-143641]

Type: TSQL

DB-Name: GDW

For Run: 20110616 14:36:41

• Job history information *****************************

Stepname: CCMS-step 1

Command: declare @exeStmt nvarchar(2000) exec gdw.sap_backup_databases @dbList=

"GDW",@r3Db="GDW",@bDev="1",@expDays= 27,@jobName= "SAP CCMS Log Backu

p of GDW [20110616143641-4-143641]",@bkupChecksum="N",@bkupCompress="N

",@bkupType="L",@nativeBkup="N",@exeDate = "20110616143641",@bkupSim =

"N",@format = 0,@init = 0,@bkupDb = "GDW",@unload = 0,@exeStmt = @exe

Stmt OUTPUT

Status: (failure)

Message: 2528

Severity: 15

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

Last msg: Executed as user: NT AUTHORITY\SYSTEM. Incorrect syntax near '1'. [SQL

STATE 42000] (Error 102) Incorrect syntax near the keyword 'with'. If

this statement is a common table expression, an xmlnamespaces clause

or a change tracking context clause, the previous statement must be te

rminated with a semicolon. [SQLSTATE 42000] (Error 319) DBCC executio

n completed. If DBCC printed error messages, contact your system admin

istrator. [SQLSTATE 01000] (Error 2528). The step failed.

<----

---

End of Job Step History -

---

>

anybody know why?

thx

[former_member189546]

Hello,

Please, check that your tape device defined does not contain

any special characters as a hyphen ('-'), a dot ('.'), etc...

In that case a solution would be as simple as renaming the device,

please review very carefully following Note :

1061294 - Syntax error in explain for stored procedure sap_XPL.

regards,

John Feely