SQL Backup Error

[Former Member]

Hello,

We are trying to run a full backup from TR Code - DB13 for SAP database. We can run the jobs successfully when run directly from SQL Management. We have assigned a Device pointing to Disk in the system. We are not trying to backup to Tape.

We are getting the below error during execution.

• Job History Information *******************

Jobname: SAP CCMS Full DB Backup of DEV [20090419100831-7-100831]

Type: TSQL

DB-Name: DEV

For Run: 19.04.2009 10:09:30

Stepname: CCMS-step 1

Command: declare @exeStmt nvarchar(2000) exec dev.sap_backup_databases @dbList="DEV",@r3Db="DEV",@bDev="Cockpit Device",@expDays=27,@bkupChecksum="Y",@jobName= "SAP CCMS Full DB Backup of DEV [20090419100831-7-100831]",@bkupType="F",@nativeBkup="N",@exeDate ="20090419100831",@bkupSim = "N",@format = 0,@init = 0,@bkupDb = "DEV",@unload = 0,@exeStmt = @exeStmt 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 the keyword 'WITH'. [SQLSTATE 42000] (Error 156) Incorrect syntax near the keyword 'with'. If this statement is a common table expression or an xmlnamespaces clause, the previous statement must be terminated with a semicolon. [SQLSTATE 42000] (Error 319) DBCC execution completed. If DBCC printed error messages, contact your system administrator. [SQLSTATE 01000] (Error 2528). The step failed.

***************

<----

---

End of Job History -

---

>

Please guide for any possible solutions.

Thanks

Kalpesh.

[Former Member]

When SAP generates the script to run the backup job, it does not put the device name in proper inverted commas. We had named the device with two words containing a space. So we removed the space from the backup device with one word only and the job runs successfully without any errors.

[Former Member]

Hi Kalpesh

i have the same problem in scheduling the backup through db13 on disk in mssql.is there any configuration has to be made.can u suggest me the steps to take backup through db13 on disk

[Former Member]

Hi all

First if your database SQL server and you want to take a backup on disk or USB or EXT HDD so to take a full backup throw db13 u must do as follow:

1- connect to ur SQL server management studio .. note: almost ur server name: localhost

2-under localhost choose==>server object==>Backup Devices then right click on it and choose new backup device.

3-Device name ( must be with no spaces ) here is ur issue must be one word***

4-choose ur file path then click on ok and close it

5- stop and start your sap system to read your new configuration from database

6-go throw db13 and chose full database backup

7- you will find ur new device chose it then uncheck any parameters related to tape then click on execute Immediately .

i hope this will help you or anyone

[Former Member]

Hi,

Go through SAP note 937906.

Regards,

Sachin Rane.

[Former Member]

Hello Sachin,

Thanks for help. SAP note 937906 does not seem to be related to our problem.

There job does not run at all, with syntax error.

Thanks,

Kalpesh.

[Former Member]

Hello to all,

The problem is resolved.

When SAP generates the script to run the backup job, it does not put the device name in proper inverted commas. We had named the device with two words containing a space. So we removed the space from the backup device with one word only and the job runs successfully without any errors.

Thanks and regards,

Kalpesh.