How can we help you today? How can we help you today?

Log Shipping : Issue in GUI Activity History

Hello...

Using Log Shipping, with multiple threads on the backup.

Since changing to multiple threads, I've noticed a sporadic issue in SQL Backup GUI when viewing Activity History on the destination server.

About 50% of the time when I launch the GUI and click to the desintation server, each transaction log restore will have multiple line items for each restore - however both lines will not be "complete". Closing the program, and reopening often resolves this - only showing a single entry per scheduled job.

For instance, presently I see two lines...

Line 1 shows the SQL Backup vault icon, successful outcome, a time of 18 seconds, 1 file ... and all the other normal items.

Line 2 does not display the vault icon, a time of 0 seconds, a blank file column.

Both lines show the same date.

Both servers, and the local sql backup gui are all running the latest version... 5.1.0.2781. SQL 2000.
csm
0

Comments

1 comment

  • Daniel Handley
    Thanks for letting us know about this.

    We have found a problem with multi thread restores where the entire file has to be read before a restore proceeds, thus slowing it down. This will be fixed in version 5.2.

    I will add this additional information to the recorded bug so that it can be verified and hopefully solved.

    Regards
    Dan
    Daniel Handley
    0

Add comment

Please sign in to leave a comment.