on 07-06-2016 10:31 AM
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 *****************************
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Check this note.
142731 - DBCC checks of SQL server
Also check space on tapes/server/db.
Kind Regards,
Johan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
check if tape0 drive is available.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Jayesh,
Looks like issue with accessing tape drive. Please make sure that tape drive is accessible and properly mounted.
Thanks,
Manish
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
10 | |
10 | |
9 | |
7 | |
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.