Backup Succeeds but fails on VERIFY

msalasmsalas Posts: 19
edited June 10, 2010 9:24AM in SQL Backup Previous Versions
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]'[email protected]', 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]

Comments

  • peteypetey Posts: 2,358 New member
    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.
    Peter Yeoh
    SQL Backup Consultant Developer
    Associate, Yohz Software
    Beyond compression - SQL Backup goodies under the hood, updated for version 8
Sign In or Register to comment.