Skip to Content
0
Former Member
Sep 03, 2007 at 07:59 AM

Ms SQL Full DB backup error again....

222 Views

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