Skip to Content
0
Jul 06, 2016 at 09:31 AM

Tape backup failed

27 Views

Hie experts,

We are unable to take backup on tape drive... Showing the error message. please help

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

Jobname: SAP CCMS Log Backup of PRD [20141004163126-0-140000]

Type: TSQL

DB-Name: PRD

For Run: 20160706 14:00:00

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

Stepname: CCMS-step 1

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

"PRD",@r3Db="PRD",@bDev="R3DUMP0",@expDays= 27,@jobName= "SAP CCMS Log

Backup of PRD [20141004163126-0-140000]",@bkupChecksum="Y",@bkupCompr

ess="N",@bkupType="L",@nativeBkup="N",@exeDate = "20141006140000",@bku

pSim = "N",@format = 0,@init = 0,@bkupDb = "PRD",@unload = 0,@exeStmt

= @exeStmt OUTPUT

Status: (failure)

Message: 4027

Severity: 16

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

Last msg: Executed as user: prd. Mount tape for BACKUP LOG of database 'PRD' on

tape drive '\\.\tape0'. [SQLSTATE 42000] (Error 4027). The step faile

d.

<------------- End of Job Step History --------------->

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