cancel
Showing results for 
Search instead for 
Did you mean: 

db13 backup error with mssql as database

Former Member
0 Kudos

Hi

While scheduling the backup through db13 i got the following error msg.i mdoing the backup on disk

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

Jobname:

SAP CCMS Full DB Backup of DEV,master,msdb [20090825163455]

Taskname: Step1

Type: TSQL

DB-Name: DEV

Lastrun: 20090826 07:00:01

Nextrun: not scheduled

Created: 2009-08-25 16:34:55.

Command: dev.sap_backup_databases

@dblist="DEV,master,msdb",@r3db="DEV",@bdev="db1

3 backup",@unload=0,@verify=0,@jobname= "SAP CCMS

Full DB Backup of DEV,master,msdb [20090825163455]

"

Descript: SAP CCMS JOB

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

For run: 20090826 07:00:00

Status: 0 (failure) (see DB error log)

Message: 156

Severity: 15

Duration: 0 hours, 0 minutes, 0 seconds

Duration: 0 hours, 0 minutes, 0 seconds

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). The step failed.

i have set the backup device name as db13 backup. is that the problem.

Plz help me

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

Hi pranav kumar,

Have you created this backup volume?

Regards

Ashok Dalai

Former Member
0 Kudos

Hi

The problem has been resolved.

Former Member
0 Kudos

Hi Pranav,

Could you please tell us what was the issue so that if any body face the issue again then he will get help from this thread.

Regards

Ashok Dalai

Former Member
0 Kudos

Hi Ashok

Actually the backup device name was not properly configured. i just removed the space from backup device name.Now its working fine

Former Member
0 Kudos

Hi pranav kumar,

Have you created this backup volume?

Regards

Ashok Dalai

Former Member
0 Kudos

Hi pranav kumar,

Have you created this backup volume name?

Regards

Ashok Dalai