Options
corrupted tlog in log shipping
jwilley
Posts: 23
Hoping someone can recommend a workflow here -- over the weekend our log shipping job stopped due to one of the tlog files being corrupted. unfortunately, I had set the file retention time on the source server to 24h -- and the 24 had passed by the time I got to work and saw the problem -- therefore, I don't have a copy of the corrupted file on the source server (a lession learned!).
Please give suggestions as to what I should do to sort this out -- do I really have to delete/suspend the jobs on both source and target and start over? Note the database is 60GB compressed -- it takes 24 hrs to transfer a full backup to the target server. The target database is fne up to the problem and for what it's worth, I 50 or so tlogs after the problem (I tried to restore the next one in the list but got an error that its starting ID was too recent).
Any help, greatly appreciated.
Please give suggestions as to what I should do to sort this out -- do I really have to delete/suspend the jobs on both source and target and start over? Note the database is 60GB compressed -- it takes 24 hrs to transfer a full backup to the target server. The target database is fne up to the problem and for what it's worth, I 50 or so tlogs after the problem (I tried to restore the next one in the list but got an error that its starting ID was too recent).
Any help, greatly appreciated.
Comments
SQL Backup Consultant Developer
Associate, Yohz Software
Beyond compression - SQL Backup goodies under the hood, updated for version 8