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

[Former Member · Accepted solution]

Does it not work with the "format media" option?

[ThomasKjelsrud · Accepted solution]

Hi Kan,

So your suggestion is that I should run a backup with the format media option selected? I believe I have tried that, but I will nevertheless give it another go.

Will keep this thread open in the mean time.

Thomas