Database Backup on tape

[ganesh_borase2]

Hello everybody,

I have been suffer from problem that

1. I can access the tape drive using NTBACKUP for database backup.

But when i trying to open the Media contents (in SQL 2005, and try to

open the backup device R3DUMP0) then it generate the error message

"cannot open the backup device 'R3DUMP0(
.\tape0)', operating

system error 2(the system cannot find the file specified)"

2. when trying to take backup from SAP, then it generate the Error

• SQL Job information ******************************

Jobname: SAP CCMS Full DB Backup of master,RPD 20090620094326-6-094326

Type: TSQL

DB-Name: RPD

For Run: 20090620 09:43:26

• Job history information******************

Stepname: CCMS-step 1

Command: declare @exeStmt nvarchar(2000) exec rpd.sap_backup_databases @dbList=

"master,RPD",@r3Db="RPD",@bDev="R3DUMP0",@expDays= 27,@jobName= "SAP C

CMS Full DB Backup of master,RPD 20090620094326-6-094326",@bkupCheck

sum="N",@bkupType="F",@nativeBkup="N",@exeDate = "20090620094326",@bku

pSim = "N",@format = 0,@init = 1,@bkupDb = "master",@unload = 0,@exeSt

mt = @exeStmt OUTPUT

Status: (failure)

Message: 2528

Severity: 16

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

Last msg: Executed as user: NT AUTHORITY\SYSTEM. Access is denied due

to a password failure SQLSTATE 42000 (Error 3279) BACKUP DATABASE is

terminating abnormally. SQLSTATE 42000 (Error 3013) DBCC execution complete

d. If DBCC printed error messages, contact your system administrator.

SQLSTATE 01000 (Error 2528). The step failed.

<----

---

End of Job Step History -

---

>

• Job history information***********************

I have also tried ,<sid>adm user but same error is generate

Is SAPService<SID> use any additional authorization, or any additional right?

I am able to take the backup using the NTBACKUP utility on Tape.

so i not likely problem of Tape device, it is seen to the some authorization problem

please suggest me

Thanks

Ganesh

[Former Member]

Hi Ganesh,

Have a look at SAP Note - 1115746 it may help you.

Regards,

Rohit