on 09-20-2008 8:27 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.