Backup Succeeds but fails on VERIFY

msalas

Please help!
We have a backup process that keeps on failing on the VERIFY portion. Tested directing the backup to local disk and network, same behavior. Did the sqbutility too. Backup successfully completes yet on the verify portion, it says that the media family on device is incorrectly formed.

Please see below message:
-SQL "BACKUP DATABASES [EMAIL] TO DISK = 'T:\SQLBAK\<database>\<AUTO>.sqb' WITH COMPRESSION = 1, MAXTRANSFERSIZE = 1048576, ERASEFILES = 10, MAILTO = [/email]'msalas@walzgroup.com', THREADCOUNT = 2, VERIFY "

---

ERRORS AND WARNINGS

---

6/9/2010 1:54:46 PM:
6/9/2010 1:54:46 PM: Verifying files:
6/9/2010 1:54:46 PM: T:\SQLBAK\EMAIL\FULL_(local)_EMAIL_20100609_135443.sqb
6/9/2010 1:54:46 PM:
6/9/2010 1:54:46 PM: SQL Server error
6/9/2010 1:54:46 PM:
6/9/2010 1:54:46 PM: SQL error 3013: SQL error 3013: VERIFY DATABASE is terminating abnormally.
6/9/2010 1:54:46 PM: SQL error 3241: SQL error 3241: The media family on device 'SQLBACKUP_A9E01DC3-5AA1-46E4-9E8D-308386EEC11C' is incorrectly formed. SQL Server cannot process this media family.

---

PROCESSES COMPLETED SUCCESSFULLY

---

6/9/2010 1:54:43 PM: Backing up EMAIL (full database) to:
6/9/2010 1:54:43 PM: T:\SQLBAK\EMAIL\FULL_(local)_EMAIL_20100609_135443.sqb

6/9/2010 1:54:43 PM: BACKUP DATABASE [EMAIL] TO VIRTUAL_DEVICE = 'SQLBACKUP_8A5F3836-8FD1-4680-BD96-FDDDD6A4AB57', VIRTUAL_DEVICE = 'SQLBACKUP_8A5F3836-8FD1-4680-BD96-FDDDD6A4AB5701' WITH BUFFERCOUNT = 12, BLOCKSIZE = 65536, MAXTRANSFERSIZE = 1048576, NAME = N'Database (EMAIL), 6/9/2010 1:54:43 PM', DESCRIPTION = N'Backup on 6/9/2010 1:54:43 PM Server: SAN-DB-02 Database: EMAIL', FORMAT

6/9/2010 1:54:44 PM: Database size : 1.294 GB
6/9/2010 1:54:44 PM: Compressed data size: 4.336 MB
6/9/2010 1:54:44 PM: Compression rate : 99.67%

6/9/2010 1:54:44 PM: Processed 2376 pages for database 'EMAIL', file 'EMAIL' on file 1.
6/9/2010 1:54:44 PM: Processed 1 pages for database 'EMAIL', file 'EMAIL_log' on file 1.
6/9/2010 1:54:44 PM: BACKUP DATABASE successfully processed 2377 pages in 0.448 seconds (43.465 MB/sec).
6/9/2010 1:54:46 PM: Validation of all backup files failed.
[/email]

---

petey

Which version of SQL Backup and SQL Server are you using? The database characteristics are a bit strange i.e. database files total 1.294 GB in size, but used pages total only ~18 MB.

Could you please send the backup file to me (peter.yeoh at red-gate.com)?

Thanks.