How can we help you today? How can we help you today?
tlovie
Activity overview Badges (0) Posts (1) Comments (4)

Comments

Sort by recent activity
I think I understand why it was failing on these databases.... dbcc checkdb was not coming back clean. Once I rectified that, the backups are fine. / comments
  1. Community
  2. SQL Backup Previous Versions
  3. SQL Backup failure on verify step
I think I understand why it was failing on these databases.... dbcc checkdb was not coming back clean. Once I rectified that, the backups are fine.
0 votes
I'm still getting errors for certain backup jobs. -SQL "BACKUP DATABASE [CFM] FILEGROUP = 'PRIMARY' TO DISK = 'G:\SQL2008\MSSQL10.SQL2008\MSSQL\Backup\<AUTO>.sqb' WITH ERASEFILES = 1b, ERASEFILES_REMOTE = 1b, MAILTO_ONERROR = 'tom@exigentsi.com', DISKRETRYINTERVAL = 30, DISKRETRYCOUNT = 10, COPYTO = '\\192.168.6.7\CFMBackup', THREADCOUNT = 3, VERIFY " ERRORS AND WARNINGS 11/22/2010 10:30:32 AM: 11/22/2010 10:30:32 AM: Verifying files: 11/22/2010 10:30:32 AM: G:\SQL2008\MSSQL10.SQL2008\MSSQL\Backup\FILE_SQL2008_CFM_20101122_102925.sqb 11/22/2010 10:30:32 AM: 11/22/2010 10:30:54 AM: SQL Server error 11/22/2010 10:30:54 AM: 11/22/2010 10:30:54 AM: SQL error 3013: SQL error 3013: VERIFY DATABASE is terminating abnormally. 11/22/2010 10:30:54 AM: SQL error 3189: SQL error 3189: Damage to the backup set was detected. 11/22/2010 10:30:54 AM: Validation of all backup files failed. PROCESSES COMPLETED SUCCESSFULLY 11/22/2010 10:29:25 AM: Backing up CFM (files/filegroups) on SQL2008 instance to: 11/22/2010 10:29:25 AM: G:\SQL2008\MSSQL10.SQL2008\MSSQL\Backup\FILE_SQL2008_CFM_20101122_102925.sqb 11/22/2010 10:29:25 AM: BACKUP DATABASE [CFM] FILEGROUP = 'PRIMARY' TO VIRTUAL_DEVICE = 'SQLBACKUP_5A317C47-7287-4458-A923-B206CEB0BB59', VIRTUAL_DEVICE = 'SQLBACKUP_5A317C47-7287-4458-A923-B206CEB0BB5901', VIRTUAL_DEVICE = 'SQLBACKUP_5A317C47-7287-4458-A923-B206CEB0BB5902' WITH BUFFERCOUNT = 18, BLOCKSIZE = 65536, MAXTRANSFERSIZE = 1048576, NAME = N'Database (CFM), 11/22/2010 10:29:25 AM', DESCRIPTION = N'Backup on 11/22/2010 10:29:25 AM Server: BASHFUL\SQL2008 Database: CFM', FORMAT 11/22/2010 10:30:31 AM: Backup data size : 7.584 GB 11/22/2010 10:30:31 AM: Compressed data size: 1.991 GB 11/22/2010 10:30:31 AM: Compression rate : 73.75% 11/22/2010 10:30:31 AM: Processed 990496 pages for database 'CFM', file 'CFM_Data' on file 1. 11/22/2010 10:30:31 AM: Processed 0 pages for database 'CFM', file 'CFM_Log' on file 1. 11/22/2010 10:30:31 AM: Processed 0 pages for database 'CFM', file 'CFM_Log2' on file 1. 11/22/2010 10:30:31 AM: Processed 1 pages for database 'CFM', file 'CFM_Log3' on file 1. 11/22/2010 10:30:31 AM: BACKUP DATABASE...FILE=<name> successfully processed 990497 pages in 59.262 seconds (130.576 MB/sec). / comments
  1. Community
  2. SQL Backup Previous Versions
  3. SQL Backup failure on verify step
I'm still getting errors for certain backup jobs. -SQL "BACKUP DATABASE [CFM] FILEGROUP = 'PRIMARY' TO DISK = 'G:\SQL2008\MSSQL10.SQL2008\MSSQL\Backup\<AUTO>.sqb' WITH ERASEFILES = 1b, ERASEFILES_R...
0 votes
How would I do that... they are ~ 2GB. I don't think I could email it. / comments
  1. Community
  2. SQL Backup Previous Versions
  3. SQL Backup failure on verify step
How would I do that... they are ~ 2GB. I don't think I could email it.
0 votes
I've done some more testing on this, and when I change the compression level to 1, it starts working. It also fails with a different error on compression level 3. / comments
  1. Community
  2. SQL Backup Previous Versions
  3. SQL Backup failure on verify step
I've done some more testing on this, and when I change the compression level to 1, it starts working. It also fails with a different error on compression level 3.
0 votes
Total activity
6
Last activity
Member since
Following
0 users
Followed by
0 users
Votes
0
Subscriptions
1