on 09-03-2007 8:59 AM
Hi all,
I have a serious problem with the db full back with respect to DB13 since a long time, in the recent times i have posted the same issue, but i cud not find the approriate solution for the same...
I had few very good responces but was not helpful for my errors...
I am posting it again as a new thread for the reason that it has again failed with a different error this time....
I request all the gurus to plz chk this error log and help me....
ERROR LOG:
Error Log:
<i><b>***************************** SQL Job information ******************************
Jobname: SAP CCMS Full DB Backup of master,msdb,BI1 [20070827090523-3-190000]
Type: TSQL
DB-Name: BI1
For Run: 20070829 19:00:00
Job history information *****************************
Stepname: CCMS-step 1
Command: declare @exeStmt nvarchar(2000) exec bi1.sap_backup_databases @dbList=
"master,msdb,BI1",@r3Db="BI1",@bDev="R3DUMP0",@expDays= 0,@bkupChecksu
m="Y",@jobName= "SAP CCMS Full DB Backup of master,msdb,BI1 [200708270
90523-3-190000]",@bkupType="F",@nativeBkup="N",@exeDate = "20070829190
000",@bkupSim = "N",@format = 1,@init = 1,@bkupDb = "master",@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: NT AUTHORITY\SYSTEM. DBCC execution completed. If DB
CC printed error messages, contact your system administrator. [SQLSTAT
E 01000] (Message 2528) Mount tape for BACKUP DATABASE of database 'm
aster' on tape drive '
.\tape0'. [SQLSTATE 42000] (Error 4027). The
step failed.
<----
End of Job Step History -
>
Stepname: CCMS-step 2
Command: declare @exeStmt nvarchar(2000) exec bi1.sap_backup_databases @dbList=
"master,msdb,BI1",@r3Db="BI1",@bDev="R3DUMP0",@expDays= 0,@bkupChecksu
m="Y",@jobName= "SAP CCMS Full DB Backup of master,msdb,BI1 [200708270
90523-3-190000]",@bkupType="F",@nativeBkup="N",@exeDate = "20070829190
000",@bkupSim = "N",@bkupDb = "msdb",@unload = 0,@exeStmt = @exeStmt O
UTPUT
Last msg: Executed as user: NT AUTHORITY\SYSTEM. DBCC execution completed. If DB
CC printed error messages, contact your system administrator. [SQLSTAT
E 01000] (Message 2528) Mount tape for BACKUP DATABASE of database 'm
aster' on tape drive '
.\tape0'. [SQLSTATE 42000] (Error 4027). The
step failed.
<----
End of Job Step History -
>
Stepname: CCMS-step 3
Command: declare @exeStmt nvarchar(2000) exec bi1.sap_backup_databases @dbList=
"master,msdb,BI1",@r3Db="BI1",@bDev="R3DUMP0",@expDays= 0,@bkupChecksu
m="Y",@jobName= "SAP CCMS Full DB Backup of master,msdb,BI1 [200708270
90523-3-190000]",@bkupType="F",@nativeBkup="N",@exeDate = "20070829190
000",@bkupSim = "N",@bkupDb = "BI1",@unload = 1,@exeStmt = @exeStmt OU
TPUT
Last msg: Executed as user: NT AUTHORITY\SYSTEM. DBCC execution completed. If DB
CC printed error messages, contact your system administrator. [SQLSTAT
E 01000] (Message 2528) Mount tape for BACKUP DATABASE of database 'm
aster' on tape drive '
.\tape0'. [SQLSTATE 42000] (Error 4027). The
step failed.
<----
End of Job Step History -
>
Job history information *****************************</b></i>
I have given it my best with the help of google, but found no proper help.
Can u plz help me get any sap notes on this or a appropriate solution if anyone faced the same before.
Waiting to hear from u asap...
Plz treat it as an urgent request...
REWARD POINTS assured...
Thanks in advance
Hari Haran.V
DB13 by default backups the database to the backup device "disk0" which points to location "
tape\0". You have to create a new backup device and use this device in DB13 rather than DISK0.
I recommend using maintenance plan in SQL Server 2005 for backing up SQL Server database. This is much easier and maintenance plan takes care of creating separate files with detailed logging. You can in turn setup the database mail in SQL Server 2005 and have it send a report everytime it runs. This is not possible in DB13 as far as I know.
Best of luck!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Executed as user: alq. Mount tape for BACKUP DATABASE of database 'ALQ
' on tape drive '\\.\tape0'. [SQLSTATE 42000] (Error 4027). The step
failed.
<------------- End of Job Step History --------------->
Hi,
I have received the above error while schedule the backup in SAP Drive 1
but the backup is happening in Drive 2 in tape library. Please suggest to resolve this issue.
apparently this error is due to tape unit.
Is the tape drive '
.\tape0' valid ?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
76 | |
9 | |
8 | |
7 | |
6 | |
5 | |
5 | |
5 | |
5 | |
5 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.