How can we help you today? How can we help you today?
theredmiata
Activity overview Badges (0) Posts (2) Comments (9)

Activity overview

Latest activity by theredmiata

Full install of SQL Back 5.4 needed
  1. Community
  2. SQL Backup Previous Versions
I've been tasked with documenting and performing a full disaster recovery test and one of the items I need to download is a full copy of the SQL Backup 5.x. Part of the requirement is to have all a...
1 follower 1 comment 0 votes
Restore of 'suspect' backup was successful. File Integrity check was successful, no errors. Backup size-50.4gb - 54,167,337,472 bytes. / comments
  1. Community
  2. SQL Backup Previous Versions
  3. Verify failure on Sql Backup
Restore of 'suspect' backup was successful. File Integrity check was successful, no errors. Backup size-50.4gb - 54,167,337,472 bytes.
0 votes
Ran the query: execute master..sqbdata 'SELECT * from backuphistory WHERE dbname = ''NavisionPRD'' AND backup_start > ''2008-01-09'' AND backup_start < ''2008-01-11'' '; With the results: 105 {8E4C5040-30EB-4819-B4E8-82A03C16F101} 2008-01-09 21:30:32.567 2008-01-09 21:50:18.713 D NavisionPRD 0 87.31366 1 1185 432428351488 54859328512 258.949 7 1 WATKINSMFG\GSA_SQL2005 -1 0 0 106 {43E72595-C27D-4FBA-99C7-F9A4DF7B1B12} 2008-01-10 21:30:31.030 2008-01-10 21:50:19.397 D NavisionPRD 0 87.47369 1 1187 432428351488 54167337472 256.202 7 1 WATKINSMFG\GSA_SQL2005 -1 0 0 / comments
  1. Community
  2. SQL Backup Previous Versions
  3. Verify failure on Sql Backup
Ran the query: execute master..sqbdata 'SELECT * from backuphistory WHERE dbname = ''NavisionPRD'' AND backup_start > ''2008-01-09'' AND backup_start < ''2008-01-11'' '; With the results: 105 {8E4C...
0 votes
Second straight night that the verify has failed.. same error: SQL Backup log file 1/10/2008 9:30:31 PM: Backing up NavisionPRD (full database) on NAVPRD instance to: 1/10/2008 9:30:31 PM: K:\Backup\Database\NavisionPRD.sqb 1/10/2008 9:30:31 PM: BACKUP DATABASE [NavisionPRD] TO DISK = 'K:\Backup\Database\NavisionPRD.sqb' WITH NAME = '<AUTO>', DESCRIPTION = '<AUTO>', INIT, VERIFY, ERASEFILES_ATSTART = 1, MAILTO = 'DL-NavBackupStatus@watkinsmfg.com;NavisionJobLogs@watkinsmfg.com', COMPRESSION = 1, THREADCOUNT = 7 1/10/2008 9:50:19 PM: Database size : 402.730 GB 1/10/2008 9:50:19 PM: Compressed data size: 50.447 GB 1/10/2008 9:50:19 PM: Compression rate : 87.47% Processed 18792 pages for database 'NavisionPRD', file 'Navision_Data' on file 1. Processed 18358576 pages for database 'NavisionPRD', file 'Navision_1_Data' on file 1. Processed 18690880 pages for database 'NavisionPRD', file 'Navision_2_Data' on file 1. Processed 336 pages for database 'NavisionPRD', file 'Navision_Log' on file 1. BACKUP DATABASE successfully processed 37068584 pages in 1185.259 seconds (256.202 MB/sec). 1/10/2008 9:50:19 PM: 1/10/2008 9:50:19 PM: Validating files: 1/10/2008 9:50:19 PM: K:\Backup\Database\NavisionPRD.sqb 1/10/2008 9:50:19 PM: 1/10/2008 9:50:19 PM: RESTORE VERIFYONLY FROM DISK = 'K:\Backup\Database\NavisionPRD.sqb' 1/10/2008 10:04:38 PM: Thread 0 error: Failed to service command. Error code: -2139684860 Process terminated unexpectedly. Error code: -2139684860 Device index out of range: 43 1/10/2008 10:04:38 PM: Thread 1 error: Failed to service command. Error code: -2139684860 Process terminated unexpectedly. Error code: -2139684860 Device index out of range: 43 1/10/2008 10:04:38 PM: Thread 2 error: Process terminated unexpectedly. Error code: -2139684860 Device index out of range: 43 1/10/2008 10:04:38 PM: Thread 3 error: Failed to service command. Error code: -2139684860 Process terminated unexpectedly. Error code: -2139684860 Device index out of range: 43 1/10/2008 10:04:38 PM: Thread 4 error: Failed to service command. Error code: -2139684860 Process terminated unexpectedly. Error code: -2139684860 Device index out of range: 43 1/10/2008 10:04:38 PM: Thread 5 error: Failed to service command. Error code: -2139684860 Process terminated unexpectedly. Error code: -2139684860 Device index out of range: 43 1/10/2008 10:04:38 PM: Thread 6 error: Failed to service command. Error code: -2139684860 Process terminated unexpectedly. Error code: -2139684860 Device index out of range: 43 SQL error 3013: SQL error 3013: VERIFY DATABASE is terminating abnormally. SQL error 3203: SQL error 3203: Read on "SQLBACKUP_5DFB2335-62BE-469E-8F4E-818A195F322601" failed: 995(The I/O operation has been aborted because of either a thread exit or an application request.) 1/10/2008 10:04:38 PM: Validation of all backup files failed. Help please... / comments
  1. Community
  2. SQL Backup Previous Versions
  3. Verify failure on Sql Backup
Second straight night that the verify has failed.. same error: SQL Backup log file 1/10/2008 9:30:31 PM: Backing up NavisionPRD (full database) on NAVPRD instance to: 1/10/2008 9:30:31 PM: K:\Bac...
0 votes
Has there been any progress on this issue: Last night's backup verified failed: SQL Backup log file 1/9/2008 9:30:32 PM: Backing up NavisionPRD (full database) on NAVPRD instance to: 1/9/2008 9:30:32 PM: K:\Backup\Database\NavisionPRD.sqb 1/9/2008 9:30:32 PM: BACKUP DATABASE [NavisionPRD] TO DISK = 'K:\Backup\Database\NavisionPRD.sqb' WITH NAME = '<AUTO>', DESCRIPTION = '<AUTO>', INIT, VERIFY, ERASEFILES_ATSTART = 1, MAILTO = 'DL-NavBackupStatus@watkinsmfg.com;NavisionJobLogs@watkinsmfg.com', COMPRESSION = 1, THREADCOUNT = 7 1/9/2008 9:50:18 PM: Database size : 402.730 GB 1/9/2008 9:50:18 PM: Compressed data size: 51.092 GB 1/9/2008 9:50:18 PM: Compression rate : 87.31% Processed 18768 pages for database 'NavisionPRD', file 'Navision_Data' on file 1. Processed 18712584 pages for database 'NavisionPRD', file 'Navision_1_Data' on file 1. Processed 18664704 pages for database 'NavisionPRD', file 'Navision_2_Data' on file 1. Processed 391 pages for database 'NavisionPRD', file 'Navision_Log' on file 1. BACKUP DATABASE successfully processed 37396447 pages in 1183.054 seconds (258.949 MB/sec). 1/9/2008 9:50:18 PM: 1/9/2008 9:50:18 PM: Validating files: 1/9/2008 9:50:18 PM: K:\Backup\Database\NavisionPRD.sqb 1/9/2008 9:50:18 PM: 1/9/2008 9:50:18 PM: RESTORE VERIFYONLY FROM DISK = 'K:\Backup\Database\NavisionPRD.sqb' 1/9/2008 10:02:32 PM: Thread 0 error: Failed to service command. Error code: -2139684860 Process terminated unexpectedly. Error code: -2139684860 Device index out of range: 248 1/9/2008 10:02:32 PM: Thread 1 error: Failed to service command. Error code: -2139684860 Process terminated unexpectedly. Error code: -2139684860 Device index out of range: 248 1/9/2008 10:02:32 PM: Thread 2 error: Process terminated unexpectedly. Error code: -2139684860 Device index out of range: 248 1/9/2008 10:02:32 PM: Thread 3 error: Failed to service command. Error code: -2139684860 Process terminated unexpectedly. Error code: -2139684860 Device index out of range: 248 1/9/2008 10:02:32 PM: Thread 4 error: Failed to service command. Error code: -2139684860 Process terminated unexpectedly. Error code: -2139684860 Device index out of range: 248 1/9/2008 10:02:32 PM: Thread 5 error: Process terminated unexpectedly. Error code: -2139684860 Device index out of range: 248 1/9/2008 10:02:32 PM: Thread 6 error: Failed to service command. Error code: -2139684860 Process terminated unexpectedly. Error code: -2139684860 Device index out of range: 248 SQL error 3013: SQL error 3013: VERIFY DATABASE is terminating abnormally. SQL error 3203: SQL error 3203: Read on "SQLBACKUP_8B976A59-3085-4DFC-BA16-4211C975550302" failed: 995(The I/O operation has been aborted because of either a thread exit or an application request.) 1/9/2008 10:02:33 PM: Validation of all backup files failed. Running the SQL Backup Test Utilities shows the following: 1/10/2008 11:54:35 AM Not encrypted 1/10/2008 11:54:35 AM Multiple device file: 7 1/10/2008 11:54:35 AM Compression level: 1 1/10/2008 11:54:35 AM File size: 54,859,328,512 1/10/2008 12:50:05 PM Found terminating marker for device 0, position 54,859,328,279 1/10/2008 12:50:05 PM Found terminating marker for device 1, position 54,859,328,288 1/10/2008 12:50:05 PM Found terminating marker for device 2, position 54,859,328,297 1/10/2008 12:50:05 PM Found terminating marker for device 3, position 54,859,328,306 1/10/2008 12:50:05 PM Found terminating marker for device 4, position 54,859,328,315 1/10/2008 12:50:05 PM Found terminating marker for device 5, position 54,859,328,324 1/10/2008 12:50:05 PM Found terminating marker for device 6, position 54,859,328,333 1/10/2008 12:50:05 PM File read stopped at position: 54,859,328,333 1/10/2008 12:50:05 PM Remaining: 179 1/10/2008 12:50:05 PM Validating remaining bytes... 1/10/2008 12:50:05 PM File appears to be valid 1/10/2008 12:50:05 PM File read ended at position: 54,859,328,512 I performed a restore onto another server and was successful. The last time it occured, the Check File Integrity failed and the restore failed. Is there any insight as why this error appears intermittently? What does the error mean? Ian / comments
  1. Community
  2. SQL Backup Previous Versions
  3. Verify failure on Sql Backup
Has there been any progress on this issue: Last night's backup verified failed: SQL Backup log file 1/9/2008 9:30:32 PM: Backing up NavisionPRD (full database) on NAVPRD instance to: 1/9/2008 9:30:...
0 votes
Is there any status on this issue? / comments
  1. Community
  2. SQL Backup Previous Versions
  3. Verify failure on Sql Backup
Is there any status on this issue?
0 votes
Latest update... last night's backup and verify was successful SQL Backup log file 11/20/2007 9:29:14 PM: Backing up DB (full database) on DB instance to: 11/20/2007 9:29:14 PM: K:\Backup\Database\DB.sqb 11/20/2007 9:29:14 PM: BACKUP DATABASE [DB] TO DISK = 'K:\Backup\Database\DB.sqb' WITH NAME = '<AUTO>', DESCRIPTION = '<AUTO>', INIT, VERIFY, ERASEFILES_ATSTART = 1, MAILTO = 'DL-Job@biz.com;Job@biz.com', COMPRESSION = 1, THREADCOUNT = 7 11/20/2007 9:48:39 PM: Database size : 402.730 GB 11/20/2007 9:48:39 PM: Compressed data size: 48.429 GB 11/20/2007 9:48:39 PM: Compression rate : 87.97% Processed 18520 pages for database 'DB', file 'Navision_Data' on file 1. Processed 17377208 pages for database 'DB', file 'Navision_1_Data' on file 1. Processed 18124920 pages for database 'DB', file 'Navision_2_Data' on file 1. Processed 14948 pages for database 'DB', file 'Navision_Log' on file 1. BACKUP DATABASE successfully processed 35535596 pages in 1159.160 seconds (251.136 MB/sec). 11/20/2007 9:48:39 PM: 11/20/2007 9:48:39 PM: Validating files: 11/20/2007 9:48:39 PM: K:\Backup\Database\DB.sqb 11/20/2007 9:48:39 PM: 11/20/2007 9:48:39 PM: RESTORE VERIFYONLY FROM DISK = 'K:\Backup\Database\DB.sqb' The backup set on file 1 is valid. 11/20/2007 10:07:04 PM: SQL Backup process ended. Backup Size - 52000056832kb / comments
  1. Community
  2. SQL Backup Previous Versions
  3. Verify failure on Sql Backup
Latest update... last night's backup and verify was successful SQL Backup log file 11/20/2007 9:29:14 PM: Backing up DB (full database) on DB instance to: 11/20/2007 9:29:14 PM: K:\Backup\Databas...
0 votes
petey wrote: Could you pls run a file integrity check on that backup file using our test tool? I've sent you instructions via a private message on where to obtain it. Thanks. Here are the results: 11/20/2007 8:21:35 PM Not encrypted 11/20/2007 8:21:35 PM Multiple device file: 7 11/20/2007 8:21:35 PM Compression level: 1 11/20/2007 8:21:35 PM File size: 51,814,924,288 11/20/2007 9:02:52 PM Found terminating marker for device 0, position 51,814,924,128 11/20/2007 9:02:52 PM Found terminating marker for device 1, position 51,814,924,137 11/20/2007 9:02:52 PM Found terminating marker for device 2, position 51,814,924,146 11/20/2007 9:02:52 PM Found terminating marker for device 3, position 51,814,924,155 11/20/2007 9:02:52 PM Found terminating marker for device 4, position 51,814,924,164 11/20/2007 9:02:52 PM Found terminating marker for device 5, position 51,814,924,173 11/20/2007 9:02:52 PM Found terminating marker for device 6, position 51,814,924,182 11/20/2007 9:02:52 PM File read stopped at position: 51,814,924,182 11/20/2007 9:02:52 PM Remaining: 106 11/20/2007 9:02:52 PM Validating remaining bytes... 11/20/2007 9:02:52 PM File appears to be valid 11/20/2007 9:02:52 PM File read ended at position: 51,814,924,288 / comments
  1. Community
  2. SQL Backup Previous Versions
  3. Verify failure on Sql Backup
petey wrote: Could you pls run a file integrity check on that backup file using our test tool? I've sent you instructions via a private message on where to obtain it. Thanks. Here are the re...
0 votes
After a couple of successful verifies after backup I just recieved another verify failure. SQL Backup v5.1.0.2781 SQL Server 2005 64bit 9.0.3054 SQL backup command - EXECUTE master..sqlbackup N'-SQL "BACKUP DATABASE [DB] TO DISK = ''K:\Backup\Database\DB.sqb'' WITH COMPRESSION = 1, ERASEFILES_ATSTART = 1, INIT, MAILTO = ''DL-admin@biz.com;JobLogs@biz.com'', THREADCOUNT = 7, VERIFY"' Backup size - 51,814,924,288 bytes I ran a verifyonly first (unsuccessful), full restore to another server (successful), verifyonly (unsuccessful). Error is below. I can try and ftp the backup but at close to 50gb this would take 3 - 5 days to even complete if it even complete. Any help would be appreciated. -Verify Only Verifying file: K:\NavisionPRD.sqb Thread 0 error: Device index out of range: 29 Thread 1 error: Device index out of range: 29 Thread 2 error: Device index out of range: 29 Thread 3 error: Device index out of range: 29 Thread 4 error: Device index out of range: 29 Thread 5 error: Device index out of range: 29 Thread 6 error: Device index out of range: 29 SQL error 3013: SQL error 3013: VERIFY DATABASE is terminating abnormally. SQL error 3203: SQL error 3203: Read on "SQLBACKUP_9F78AAA9-B70D-48A2-9368-6F1687D2DE62" failed: 995(The I/O operation has been aborted because of either a thread exit or an application request.) SQL Backup exit code: 790 SQL error code: 3203 exitcode 790 sqlerrorcode 3203 filename001 K:\NavisionPRD.sqb -Restore to a different db server Restoring NavisionPRD (database) from: K:\NavisionPRD.sqb Processed 18512 pages for database 'NavisionPRD', file 'Navision_Data' on file 1. Processed 17323728 pages for database 'NavisionPRD', file 'Navision_1_Data' on file 1. Processed 18101312 pages for database 'NavisionPRD', file 'Navision_2_Data' on file 1. Processed 396 pages for database 'NavisionPRD', file 'Navision_Log' on file 1. RESTORE DATABASE successfully processed 35443948 pages in 2524.857 seconds (114.999 MB/sec). SQL Backup process ended. exitcode 0 sqlerrorcode 0 filename001 K:\NavisionPRD.sqb -Verify Only after successful Restore Verifying file: K:\NavisionPRD.sqb Thread 0 error: Process terminated unexpectedly. Error code: -2139684860 Device index out of range: 52 Thread 1 error: Process terminated unexpectedly. Error code: -2139684860 Device index out of range: 52 Thread 2 error: Process terminated unexpectedly. Error code: -2139684860 Device index out of range: 52 Thread 3 error: Failed to service command. Error code: -2139684860 Process terminated unexpectedly. Error code: -2139684860 Device index out of range: 52 Thread 4 error: Process terminated unexpectedly. Error code: -2139684860 Device index out of range: 52 Thread 5 error: Process terminated unexpectedly. Error code: -2139684860 Device index out of range: 52 Thread 6 error: Failed to service command. Error code: -2139684860 Process terminated unexpectedly. Error code: -2139684860 Device index out of range: 52 SQL error 3013: SQL error 3013: VERIFY DATABASE is terminating abnormally. SQL error 3203: SQL error 3203: Read on "SQLBACKUP_1224556F-D724-4B82-836F-32CC6AAD1640" failed: 995(The I/O operation has been aborted because of either a thread exit or an application request.) SQL Backup exit code: 790 SQL error code: 3203 exitcode 790 sqlerrorcode 3203 filename001 K:\NavisionPRD.sqb / comments
  1. Community
  2. SQL Backup Previous Versions
  3. Verify failure on Sql Backup
After a couple of successful verifies after backup I just recieved another verify failure. SQL Backup v5.1.0.2781 SQL Server 2005 64bit 9.0.3054 SQL backup command - EXECUTE master..sqlbackup N'-SQ...
0 votes
VerifyOnly does confirm the same error codes. The log file you mention confirms the same findings as well. Processed 171008 pages for database 'NavisionPRD', file 'Navision_Data' on file 1. Processed 16626200 pages for database 'NavisionPRD', file 'Navision_1_Data' on file 1. Processed 17301472 pages for database 'NavisionPRD', file 'Navision_2_Data' on file 1. Processed 13 pages for database 'NavisionPRD', file 'Navision_Log' on file 1. BACKUP DATABASE successfully processed 34098693 pages in 1179.384 seconds (236.849 MB/sec). 11/10/2007 9:47:07 PM: 11/10/2007 9:47:07 PM: Validating files: 11/10/2007 9:47:07 PM: K:\Backup\Database\NavisionPRD.sqb 11/10/2007 9:47:07 PM: 11/10/2007 9:47:07 PM: RESTORE VERIFYONLY FROM DISK = 'K:\Backup\Database\NavisionPRD.sqb' 11/10/2007 9:58:00 PM: Thread 0 error: Failed to service command. Error code: -2139684860 Process terminated unexpectedly. Error code: -2139684860 Device index out of range: 71 11/10/2007 9:58:00 PM: Thread 1 error: Failed to service command. Error code: -2139684860 Process terminated unexpectedly. Error code: -2139684860 Device index out of range: 71 11/10/2007 9:58:00 PM: Thread 2 error: Failed to service command. Error code: -2139684860 Process terminated unexpectedly. Error code: -2139684860 Device index out of range: 71 11/10/2007 9:58:00 PM: Thread 3 error: Process terminated unexpectedly. Error code: -2139684860 Device index out of range: 71 11/10/2007 9:58:00 PM: Thread 4 error: Failed to service command. Error code: -2139684860 Process terminated unexpectedly. Error code: -2139684860 Device index out of range: 71 11/10/2007 9:58:00 PM: Thread 5 error: Failed to service command. Error code: -2139684860 Process terminated unexpectedly. Error code: -2139684860 Device index out of range: 71 11/10/2007 9:58:00 PM: Thread 6 error: Failed to service command. Error code: -2139684860 Process terminated unexpectedly. Error code: -2139684860 Device index out of range: 71 SQL error 3013: SQL error 3013: VERIFY DATABASE is terminating abnormally. SQL error 3203: SQL error 3203: Read on "SQLBACKUP_DE230C25-FF44-4497-BD7A-0115C4EE904F03" failed: 995(The I/O operation has been aborted because of either a thread exit or an application request.) 11/10/2007 9:58:00 PM: Validation of all backup files failed. 11/10/2007 9:58:01 PM: Mail sent successfully to: / comments
  1. Community
  2. SQL Backup Previous Versions
  3. Verify failure on Sql Backup
VerifyOnly does confirm the same error codes. The log file you mention confirms the same findings as well. Processed 171008 pages for database 'NavisionPRD', file 'Navision_Data' on file 1. Process...
0 votes
Total activity
12
Last activity
Member since
Following
0 users
Followed by
0 users
Votes
0
Subscriptions
1