Errors during backup of MSSQL 2005 using DB13

[ThomasKjelsrud]

Hi,

I have an ECC 5.0 system, and when I try to perform any kind of backup of a MSSQL 2005 database using DB13 I get an error like this:

Modified:  2006-12-05 11:43:55.                                    
Command:    pc1.sap_backup_databases                               
             @dblist="PC1,master,msdb",@r3db="PC1",@bdev="PC1      
           _v2",@unload=0,@jobname= "SAP CCMS Full DB Backup       
           of PC1,master,msdb [20061205114354]"                    
Descript: SAP CCMS JOB                                                                                
*********** Task history information ***********                   
For run:   20061205 23:00:00                                       
Status:    0          (failure)   (see DB error log)               
Message:   3013                                                    
Severity:  16                                                      
Duration:  0 hours, 0 minutes, 0 seconds                           
Last msg:  Executed as user: NT AUTHORITYSYSTEM. DBCC execut      
           ion completed. If DBCC printed error messages, con      
           tact your system administrator. [SQLSTATE 01000] (      
           Message 2528)  The user-specified MEDIANAME "ID05S      
           " does not match the MEDIANAME "ID29S" of the devi      
           ce "PC1_v2(D:BackupPC1_2.bak)". [SQLSTATE 42000]      
            (Error 4037)  BACKUP DATABASE is terminating abno      
           rmally. [SQLSTATE 42000] (Error 3013).  The step  
           failed.                                                 

The strange thing is that if I create a new backup device in MS SQL Server Management Studio, and assign a backup job to use this backup device, the backup is successfull... but only the first time I schedule the backup. Following backup attempts to same device fails with the error message above.

Any ideas, anyone?

Regards,

Thomas

null

[ThomasKjelsrud]

This question has been answered

[Former Member]

Please post the answer so that it will be helpful when someone faces similar issue.

[ThomasKjelsrud]

Hi Ramesh,

That solution to my problem was that I did not "tick" the "Format Media" option when I scheduled my backups. Now the backups run successfully.

Thomas

[Former Member]

Hi, people.

My schuled backups don't have the option "Format Media" 'ticked', but I'm still getting that error.

It seems that SAP tries to update the <i>medianame</i> with the day of the run. How can I prevent it for doing that?

Thanks