The user-specified MEDIANAME does not match the MEDIANAME of the device

[Former Member]

Hello, Experts.

I'm receiving the message below (db13) when my scheduled backup job runs for the second time and then. I identified that SAP tries to use a <i>medianame</i> that contains the day the of the run, so the SAP <i>medianame</i> changes everyday.

Thanks in advance.

• SQL Task information ************************

Jobname: SAP CCMS User database Backup of PHD [20071016141854-2-141854]

Stepname: Step1

Type: TSQL

DB-Name: HRD

Command: hrd.sap_backup_userdb @dbnames="PHD",@bkuptype="

F",@bdev="PHDBKP",@unload=0,@init=1,@verify=0,@j

obname= "SAP CCMS User database Backup of PHD [2

0071016141854-2-141854]"

• Task history information *******************

For Run: 20071016 14:18:54

Status: (failure)

Message: 3013

Severity: 16

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

Last msg: Executed as user: NT AUTHORITY\SYSTEM. DBCC execut

ion completed. If DBCC printed error messages, con

tact your system administrator. [SQLSTATE 01000] (

Message 2528) <b>The user-specified MEDIANAME "UF16S

" does not match the MEDIANAME "" of the device "P

HDBKP(f:\backups\PHDBACKUPFILE)"</b>. [SQLSTATE 42000]

(Error 4037) BACKUP DATABASE is terminating abno

rmally. [SQLSTATE 42000] (Error 3013). The step f

ailed.

• Task history information *******************

[clas_hortien · Accepted solution]

Hello,

during the init and format of a tape every tape gets a medianame and a expiration date. As long as the expiration date is not reached, you cannot overwrite the tape with another medianame. The transactionlog tape that gets formatted through the DB13 can be used only for one day. The expiration time is 28 days, so that you can use this tape again in 4 weeks. This will ensure that you have at least 4 weeks of backups for your database.

See details in:

http://help.sap.com/saphelp_nw70/helpdata/en/ec/9e1802dd600947abafd2248518697f/frameset.htm

--> General Administration

--> Database Administration

--> MS SQL Server

Regards

Clas

[Former Member · Accepted solution]

Hello Clas, Thanks for the quick response.

The problem is that I have this working now, but I'm not able to create one by myself.

I'm daily writing 3 backups to a disk directory (ECC, Portal user data and Log). Some hours latter, another agent makes the backup of the entire directory to the tape.

Any other suggestion?

Thanks again.

[Former Member]

Suddenly worked. Suggestions were helpful.