cancel
Showing results for 
Search instead for 
Did you mean: 

Database backup error

ganesh_borase2
Participant
0 Kudos

Hello everybody, when I had planning the database backup from database planning calander, i have set the msdb, differential backup, on hard disk, then following error is rises

SQL Task information

Jobname: SAP CCMS Diff DB Backup of msdb [20081209074821-2-080000]

Stepname: Step1

Type: TSQL

DB-Name: IDS

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

db="IDS",@bdev="Drive E",@unload=0,@verify=0,@jo

bname= "SAP CCMS Diff DB Backup of msdb [2008120

9074821-2-080000]"

Task history information

For Run: 20081209 08:00:00

Status: (failure)

Message: 319

Severity: 15

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

Last msg: Executed as user: NT AUTHORITY\SYSTEM. DBCC execut

ion completed. If DBCC printed error messages, con

tact your system administrator. [SQLSTATE 01000] (

Message 2528) Incorrect syntax near the keyword '

WITH'. [SQLSTATE 42000] (Error 156) Incorrect syn

tax near the keyword 'with'. If this statement is

a common table expression or an xmlnamespaces clau

se, the previous statement must be terminated with

a semicolon. [SQLSTATE 42000] (Error 319). The s

tep failed.

will anybody tell me the correct reason for the database fail,

I think may be sapce in "@bdev="Drive E" this statement

thanks

Ganesh

Accepted Solutions (0)

Answers (1)

Answers (1)

ganesh_borase2
Participant
0 Kudos

I had solved