How can we help you today? How can we help you today?
andriancruz
Activity overview Badges (0) Posts (6) Comments (10)

Comments

Sort by recent activity
Thanks a lot! this is very helpful to me. Regards, Andrian / comments
  1. Community
  2. SQL Backup Previous Versions
  3. RE: Restored Multiple Backup LOGS
Thanks a lot! this is very helpful to me. Regards, Andrian
0 votes
Thank you Dan for the reply. Regards, Andrian / comments
  1. Community
  2. SQL Backup Previous Versions
  3. RE: SQL Backup failed with exit code: 882 SQL error code: 0
Thank you Dan for the reply. Regards, Andrian
0 votes
Thank you so much Peter for the reply. Regards, Andrian / comments
  1. Community
  2. SQL Backup Previous Versions
  3. SQL Backup File Converter
Thank you so much Peter for the reply. Regards, Andrian
0 votes
Thank you so much Peter for the reply. Regards, Andrian / comments
  1. Community
  2. SQL Backup Previous Versions
  3. Restore DB - Percent Completion
Thank you so much Peter for the reply. Regards, Andrian
0 votes
Hi Eddie, Your right I've missing the closing two single quotation marks [image] Thanks a lot for the help it's working fine now. Cheers! Regards, Andrian / comments
  1. Community
  2. SQL Backup Previous Versions
  3. Restore with NORECOVERY option isssue
Hi Eddie, Your right I've missing the closing two single quotation marks Thanks a lot for the help it's working fine now. Cheers! Regards, Andrian
0 votes
Hi Peter, Thanks a lot for the help. After updating SQL Backup we're able to read now the files. [image] Cheers! Regards, Andrian / comments
  1. Community
  2. SQL Backup Previous Versions
  3. SQL Backup exit code: 610
Hi Peter, Thanks a lot for the help. After updating SQL Backup we're able to read now the files. Cheers! Regards, Andrian
0 votes
Hi Peter, I'm able to execute the RESTORE SQBHEADERONLY and no issue found. SQL Backup v7.3.2.12 Reading SQB file header of "Drive:Filename.sqb" Backup group ID : 67803373 File number : 1 of 1 Threads : 7 (multi-threaded file) Backup type : 1 (Database) Native backup size : 9.281 GB Database size : 10.990 GB Backup start : Monday, February 02, 2015 12:06:13 AM Backup end : Monday, February 02, 2015 12:08:35 AM Server name : Servername Database name : Databasename First LSN : 13281000000067800037 Last LSN : 13281000000069400001 Checkpoint LSN : 13281000000067800037 Database backup LSN : 13281000000062800037 (21 row(s) affected) name value exitcode 0 sqlerrorcode 0 filename001 DriveFilename.sqb (3 row(s) affected) But when execute RESTORE FILELISTONLY I'm still getting same issue: Msg 1, Level 15, State 1, Line 0 Reading filelist of "DriveFilename.sqb" ReadFile failed for file: Drive:Filename.sqb at position: 0 2/3/2015 3:42:48 PM: Re-attempt: 1 2/3/2015 3:43:18 PM: Re-attempt: 2 2/3/2015 3:43:48 PM: Re-attempt: 3 2/3/2015 3:44:18 PM: Re-attempt: 4 2/3/2015 3:44:48 PM: Re-attempt: 5 2/3/2015 3:45:19 PM: Re-attempt: 6 2/3/2015 3:45:49 PM: Re-attempt: 7 2/3/2015 3:46:19 PM: Re-attempt: 8 2/3/2015 3:46:50 PM: Re-attempt: 9 2/3/2015 3:47:20 PM: Re-attempt: 10 2/3/2015 3:47:20 PM: SetFilePointerEx error: The parameter is incorrect. 2/3/2015 3:47:50 PM: SetFilePointerEx error: The parameter is incorrect. SQL Backup exit code: 610 LogicalName PhysicalName Type FileGroupName Size MaxSize Regards, Andrian / comments
  1. Community
  2. SQL Backup Previous Versions
  3. SQL Backup exit code: 610
Hi Peter, I'm able to execute the RESTORE SQBHEADERONLY and no issue found. SQL Backup v7.3.2.12 Reading SQB file header of "Drive:Filename.sqb" Backup group ID : 67803373 File number ...
0 votes
Hi Peter, Yes, after the the file integrity check "File Is Valid" and the Disk sector size is 4096 bytes after Misc tests. Regards, Andrian / comments
  1. Community
  2. SQL Backup Previous Versions
  3. SQL Backup exit code: 610
Hi Peter, Yes, after the the file integrity check "File Is Valid" and the Disk sector size is 4096 bytes after Misc tests. Regards, Andrian
0 votes
Hi Peter, Thank you for your the reply. Below are the script I'm using to restore the database using FILELISTONLY command. I'm using query analyzer using MSSQL Management Studio. --Script: EXECUTE master..sqlbackup '-SQL "RESTORE FILELISTONLY FROM DISK = ''DriveFilename.sqb''"' GO --Results: Msg 1, Level 15, State 1, Line 0 Reading filelist of "Drive:Filename.sqb" ReadFile failed for file: DriveFilename.sqb at position: 0 1/29/2015 2:38:06 PM: Re-attempt: 1 1/29/2015 2:38:36 PM: Re-attempt: 2 1/29/2015 2:39:06 PM: Re-attempt: 3 1/29/2015 2:39:36 PM: Re-attempt: 4 1/29/2015 2:40:06 PM: Re-attempt: 5 1/29/2015 2:40:36 PM: Re-attempt: 6 1/29/2015 2:41:06 PM: Re-attempt: 7 1/29/2015 2:41:36 PM: Re-attempt: 8 1/29/2015 2:42:06 PM: Re-attempt: 9 1/29/2015 2:42:36 PM: Re-attempt: 10 1/29/2015 2:42:36 PM: SetFilePointerEx error: The parameter is incorrect. 1/29/2015 2:43:06 PM: SetFilePointerEx error: The parameter is incorrect. SQL Backup exit code: 610 Hope you can help me to my issue. Thanks a lot Regards, Andrian / comments
  1. Community
  2. SQL Backup Previous Versions
  3. SQL Backup exit code: 610
Hi Peter, Thank you for your the reply. Below are the script I'm using to restore the database using FILELISTONLY command. I'm using query analyzer using MSSQL Management Studio. --Script: EXECUTE ...
0 votes
Hi Peter, Thank you for the email. The size of the backup file was 900+ MB and the file location sitting on SAN. Below are the results after execution: Thanks a lot! SQL Backup v7.3.2.12 Reading SQB file header of "DriveFilename.sqb" Error 560: File is missing or not accessible: DriveFilename.sqb.sqb SQL Backup exit code: 560 (6 row(s) affected) name value exitcode 560 sqlerrorcode 0 (2 row(s) affected) Regards, Andrian / comments
  1. Community
  2. SQL Backup Previous Versions
  3. SQL Backup exit code: 610
Hi Peter, Thank you for the email. The size of the backup file was 900+ MB and the file location sitting on SAN. Below are the results after execution: Thanks a lot! SQL Backup v7.3.2.12 Reading S...
0 votes
Total activity
22
Last activity
Member since
Following
0 users
Followed by
0 users
Votes
0
Subscriptions
6