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