I am log shipping from SQL 2008 database using TDE to a secondary server. Everything works fine for several weeks and then an issue comes up where the restore of a TLog gets hung and cannot be completed. At this point, all I can is re-establish log shipping
with a new backup from production. Considering the database is 400gb and the secondary server on the other side of the country, it takes the better part of a week to do this.
When running the restore log statement manually, it appears to actually do the restore or at least displays the messages about restoring xx pages but then just hangs at that point and never finishes.
Any ideas of where to start troubleshooting would be much appreciated
View Complete Post