Bakup Error

[Former Member]

Dear All,

This seems to very common issue for you all but right now it is something critical for me.

I have gone through all posts and made the necessary changes but did not yet succeeded.

We are unable to take backup of our ECC 6.0 Server on tape drive

We have Win 2008 Server with Microsoft SQL Server 2008 R2 (SP1) SP1 Enterprise Edition.

***************************** SQL Job information ******************************

Jobname: SAP CCMS Full DB Backup of PZP [20140819181817-2-050000]

Type: TSQL

DB-Name: PZP

For Run: 20140916 05:00:00

**************************** Job history information *****************************

Stepname: CCMS-step 1

Command: declare @exeStmt nvarchar(2000) exec pzp.sap_backup_databases @dbList=

"PZP",@r3Db="PZP",@bDev="R3DUMP0",@expDays= 27,@bkupChecksum="N",@jobN

ame= "SAP CCMS Full DB Backup of PZP [20140819181817-2-050000]",@bkupT

ype="F",@nativeBkup="N",@exeDate = "20140826050000",@bkupSim = "N",@fo

rmat = 0,@init = 0,@bkupDb = "PZP",@unload = 1,@exeStmt = @exeStmt OUT

PUT

Status: (failure)

Message: 2528

Severity: 16

Duration: 0 hours(s) 0 min(s) 1 sec(s)

Last msg: Executed as user: NT AUTHORITY\SYSTEM. Mount tape for BACKUP DATABASE

of database 'PZP' on tape drive '\\.\tape0'. [SQLSTATE 42000] (Error 4

027) DBCC execution completed. If DBCC printed error messages, contac

t your system administrator. [SQLSTATE 01000] (Error 2528). The step

failed.

<------------- End of Job Step History --------------->

**************************** Job history information *****************************

However we are now taking backup on HDD successfully.

PLease guide me to resolve this issue ASAP

any reply would be appriciated

Thanks in Advance

Amol

[Former Member]

Dear

First if your database SQL server and you want to take a backup on disk or USB or EXT HDD so to take a full backup throw db13 u must do as follow:

1- connect to ur SQL server management studio .. note: almost ur server name: localhost

2-under localhost choose==>server object==>Backup Devices then right click on it and choose new backup device.

3-Device name ( must be with no spaces ) here is ur issue must be one word***

4-choose ur file path then click on ok and close it

5- stop and start your sap system to read your new configuration from database

6-go throw db13 and chose full database backup

7- you will find ur new device chose it then uncheck any parameters related to tape then click on execute Immediately .

i hope this will help you or anyone

[Former Member]

Hello Rajendra,

As i said, we are able to take backup on ext HDD but unable to take backup o Tape Device.

Regards,

Amol 

[Former Member]

Dear

Are you able to see the tape device in SQL Management Studio? if so try to create a dummy database and try to backup.

Uninstall and update the tape drivers on the production server and then check whether you are able to backup.

check the space which assign to tape device normally it could be the problem normally we assign space 400gb

in initial stage but later the prd space increasing and you might face that issue check your init.SID.SAP for space issue

Regards,

[Sriram2009]

Hi Amol

Could you refer the SAP Note 937906

Share you system SPS level?

BR

SS