What are the challenges you face when working across database platforms? Take the survey

Log Shipping : Issue in GUI Activity History

csmcsm Posts: 17
edited June 25, 2007 11:55AM in SQL Backup Previous Versions

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... SQL 2000.


  • Options
    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.

    Daniel Handley
    Red Gate Software Ltd
Sign In or Register to comment.