The following error message occurs when I attempt to backup with SAP transaction DB13:
***************************** 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 AUTHORITYSYSTEM. Access is denied due to a password failure [SQLSTATE 42000] (Error 3279) BACKUP DATABASE is terminat
ing 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 am able to backup using NTBACKUP on the tape, however when I try opening the Media Contents [in SQL server 2005 - when I right click on R3DUMP0] I receive an error message that indicates I cannot open the backup device ['R3DUMP0(.tape0)', operating system error 2 (the system cannot find the file specified)].
How can I access the tape0 for backup purpose from SQL Server 2005?
Software/Hardware used:
ASKED:
July 6, 2009 5:21 PM
UPDATED:
July 6, 2009 7:49 PM