Activity overview
Latest activity by sioman88
This maybe totally unrelated to this issue, but I would also like to know if there is any RedGate tool/software to allow user read the data and the transaction detail in a transaction log file (.sqb)? / comments
This maybe totally unrelated to this issue, but I would also like to know if there is any RedGate tool/software to allow user read the data and the transaction detail in a transaction log file (.sqb)?
Thank you for the information, Eddie.
I found a post about exit code 680: http://www.red-gate.com/supportcenter/c ... 0903000366. And this issue seems to be similar to the situation I am having (restore failed due to LSN, although I am pretty sure they are different type of error).
I followed the instruction on the post, which is "to restore them one at a time using WITH STANDBY in date order using the extended stored procedure. This will negate the need for the SQL Backup header and restore these troublesome files in order". However, I am still getting error 4305.
So right now, I am going to try the second solution on the post, which is to use the SQBHeaderFix utility. Would you please let me know if SQBHeaderFix can fix the LSN in the .sqb files if I provide a disconnected backup set? Also, SQBHeaderFix only takes in non-encrypted files, does Red Gate has any standalone decrypt application that I can use?
Thanks again. / comments
Thank you for the information, Eddie.
I found a post about exit code 680: http://www.red-gate.com/supportcenter/c ... 0903000366. And this issue seems to be similar to the situation I am having (r...
Workaround solution for Error 4305
I am using full backup files and transaction log files (.sqb) to restore database on SQL Backup 6.4. However, there are days that we cannot recover neither the transaction log files nor the full ba...