Backup Error

[Former Member]

Dear SAP EXPERTS,

I am getting error in backup. I am trying to take backup on hard disk.

Pls suggest what I have to do?

SQL Task information

Jobname: SAP CCMS Full DB Backup of master,msdb,GAL [20080827184228-4-230000]

Stepname: Step1

Type: TSQL

DB-Name: GAL

Command: gal.sap_backup_databases @dblist="master,msdb,GA

L",@r3db="GAL",@bdev="R3HDD2",@unload=0,@verify=

0,@format=1,@jobname= "SAP CCMS Full DB Backup o

f master,msdb,GAL [20080827184228-4-230000]"

Task history information

For Run: 20080918 23:00:00

Status: (failure)

Message: 3013

Severity: 16

Duration: 12 hours(s) 42 min(s) 4 sec(s)

Last msg: Executed as user: GODREJINDS\sqlservice. ...f DBCC

printed error messages, contact your system admin

istrator. [SQLSTATE 01000] (Message 2528) Process

ed 376 pages for database 'master', file 'master'

on file 1. [SQLSTATE 01000] (Message 4035) Proces

sed 2 pages for database 'master', file 'mastlog'

on file 1. [SQLSTATE 01000] (Message 4035) BACKUP

DATABASE successfully processed 378 pages in 0.91

7 seconds (3.376 MB/sec). [SQLSTATE 01000] (Messag

e 3014) Processed 1008 pages for database 'msdb',

file 'MSDBData' on file 2. [SQLSTATE 01000] (Mess

age 4035) Processed 2 pages for database 'msdb',

file 'MSDBLog' on file 2. [SQLSTATE 01000] (Messag

e 4035) BACKUP DATABASE successfully processed 10

10 pages in 2.410 seconds (3.431 MB/sec). [SQLSTAT

E 01000] (Message 3014) Cannot open backup device

'R3HDD2(W:\backup\backup1)'. Operating system err

or 3(The system cannot find the path specified.).

[SQLSTATE 42000] (Error 3201) BACKUP DATABASE is

terminating abnormally. [SQLSTATE 42000] (Error 30

13). The step failed.

Task history information

Thanks & Regards,

Pramod Mishra

[Former Member · Accepted solution]

Hi Pramod,

it seems that the main error is:

Cannot open backup device

'R3HDD2(W:\backup\backup1)'. Operating system err

or 3(The system cannot find the path specified.).

Does this patch already exist? W:\backup\backup1

You can also try to create a backup device in SQL Server Management Studio before you start the backup. This can be done under: Server Objects --> rightclick on "Backup Devices" then you can enter a new backup device name and the related path

Regards,

Beate

[Former Member · Accepted solution]

thank u.

problem is solved.

points to u.

pramod