Backup Succeeds but fails on VERIFY
msalas
Posts: 19
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]
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]
Comments
Could you please send the backup file to me (peter.yeoh at red-gate.com)?
Thanks.
SQL Backup Consultant Developer
Associate, Yohz Software
Beyond compression - SQL Backup goodies under the hood, updated for version 8