SQL-Server 2005 & Backup problems

[Former Member]

hello,

after a migration from HP-UX/Oracle to WIN/SQL-Server 2005 I have problems with the backup:

I've created 2 backupdevices (1 for fullbackup, the other for the logfiles).

When doing the backup (trancaction db13) with the following parameters I always get an error

parameters:

databases to be backed up: master, msdb, BW2

device: bw2_full (disk)

Unload(Tape Only): unmarked

Initialize Media(= Overwrite Old Contents): marked

Verify Backup: unmarked

Format Media (Warning: All Data Will Be Deleted): unmarked

Expiration Period for Backup Volumes: 0 Days

When the backupfile does not exist the backup works fine, but not when the file exists.

logfile:

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

Jobname:

SAP CCMS Full DB Backup of BW2,master,msdb [20090408163040]

Taskname: Step1

Type: TSQL

DB-Name: BW2

Lastrun: 20090415 00:00:00

Nextrun: 20090422 00:00:00

Created: 2009-04-08 16:30:40.

Command: bw2.sap_backup_databases

@dblist="BW2,master,msdb",@r3db="BW2",@bdev="BW2

_FULL",@expdays=00,@unload=0,@init=1,@verify=0,@jo

bname= "SAP CCMS Full DB Backup of BW2,master,msdb

[20090408163040]"

Descript: SAP CCMS JOB

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

For run: 20090415 00: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 AUTHORITY\SYSTEM. DBCC execut

ion completed. If DBCC printed error messages, con

tact your system administrator. [SQLSTATE 01000] (

Message 2528) The user-specified MEDIANAME "ID15S

" does not match the MEDIANAME "ID14S" of the devi

ce "BW2_FULL(E:\BACKUP\BW2_FULL.bak)". [SQLSTATE 4

2000] (Error 4037) BACKUP DATABASE is terminating

abnormally. [SQLSTATE 42000] (Error 3013). The s

tep failed.

kind regards,

bernd

[Former Member]

Hi,

try to check the backup parameters (DB13 - Full Database backup):

- Init Tape

- Format Tape

Regards,

Raul.

[Former Member]

Specifies the media name, a maximum of 128 characters, for the entire backup media set. If MEDIANAME is specified, it must match the previously specified media name already existing on the backup volume(s). If not specified or if the SKIP option is specified, there is no verification check of the media name.

Thank you,

Shyam

[Former Member]

Check out

[http://sap.ittoolbox.com/groups/technical-functional/sap-basis/database-backup-error-error3013-617415]

 (Error 4037) BACKUP DATABASE is terminating

Check for 4037

[http://msdn.microsoft.com/en-us/library/aa937590(SQL.80).aspx]