Tape backup failed

[former_member259231]

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  *****************************

[kaus19d]

Hi ,

Hope the issue is sorted out till now. If sorted, then please do close this discussion. Please follow,     

If not sorted, we would love to get update regarding this matter?

Is a tape initialization command involved after mounting the tape? It looks like its the issue with the Tape Hardware, check with the tape hardware team, they might need to replace the Tape Writing Head. The same happened in my case also for the HP Tape Library. To prove my point, you can set the backup location on that server to a local drive & will also see that the backup is happening properly in the PRD server local drive.

Thanks,

Kaushik

[Johan_sapbasis]

Hi,

Check this note.

142731 - DBCC checks of SQL server

Also check space on tapes/server/db.

Kind Regards,

Johan

[Johan_sapbasis]

Hi,

1. Is the tape corrupt?

2. I see in your statement unload but if you are mounting the tape should it not be load?

Kind Regards.

Johan

[former_member259231]

Hi Nicolaas,

Tapes are not corrupted, they are fine...

Jayesh

[Amit_Tewatia]

check if tape0 drive is available.

[manish_singh13]

Hi Jayesh,

Looks like issue with accessing tape drive. Please make sure that tape drive is accessible and properly mounted.

Thanks,

Manish

[former_member259231]

Hie Manish,

tape drives are mounted properly...

Then too the problem has occured