Ms SQL Full DB backup error again....

[Former Member]

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

[former_member193399]

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!

[Former Member]

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.

[vincentlim826]

apparently this error is due to tape unit.

Is the tape drive '
.\tape0' valid ?