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