Skip to Content
0
Former Member
May 27, 2008 at 04:30 PM

Backup failure from DB13

20 Views

Hi all,

I am getting the following error in DB13 (full bcakup) to tape from two days.

My data base size is 280gb. Normally it takes 1:40 Minutes for full backup in tape.

but now its running around 3hrs and its get cancelling.

Please suggest me to resolve this.

Regards,

Gayathry.

Error log from DB13:

Executed as user: NT AUTHORITY\SYSTEM. DBCC execut

ion completed. If DBCC printed error messages, con

tact your system administrator. [SQLSTATE 01000] (

Message 2528) Processed 12271904 pages for databa

se 'DEV', file 'PRDDATA1' on file 1. [SQLSTATE 010

00] (Message 4035) Processed 12205560 pages for d

atabase 'DEV', file 'PRDDATA2' on file 1. [SQLSTAT

E 01000] (Message 4035) Processed 12264016 pages

for database 'DEV', file 'PRDDATA3' on file 1. [SQ

LSTATE 01000] (Message 4035) Processed 629 pages

for database 'DEV', file 'PRDLOG1' on file 1. [SQL

STATE 01000] (Message 4035) BACKUP DATABASE succe

ssfully processed 36742109 pages in 10531.878 seco

nds (28.579 MB/sec). [SQLSTATE 01000] (Message 301

4) The file on device 'R3DUMP0' is not a valid Mi

crosoft Tape Format backup set. [SQLSTATE 42000] (

Error 3242) BACKUP DATABASE is terminating abnorm

ally. [SQLSTATE 42000] (Error 3013). The step fai

led.

Error Log from ST04:

2008-05-27 21:10:39.09 backup Database backed up: Database: DEV, creation date(time): 2007/10/25(10:46:27), pages dumped: 36742200, first LSN: 17101:251857:1, last LSN: 17102:6053:1, number of dump devices: 1, device information: (FILE=1, TYPE=TAPE, ME

DIANAME='ID27S': {'R3DUMP0'}).

2008-05-27 21:11:28.95 backup BACKUP failed to complete the command dev.sap_backup_databases