I need to recover some missing records but I have a problem. My transaction log is 88GB which has been growing since 3/29/03. My last good full backup was completed on 6/8/03 and differentials occur throughout the week. I need to recover data from 6/10/03 that is missing from a table.
Can I apply the transcation log to the last good backup performed on 6/8/03? Do I have to use the last good backup from 3/29/03 and apply the massive transaction log from that point? Will I be able to use point in time recvory for this transaction log restore? Please let me know.
My maintenance plan stopped running on 3/29 which was creating transaction log backups every three hours and full database backups everyday to disk.
Can I apply the transcation log to the last good backup performed on 6/8/03? Do I have to use the last good backup from 3/29/03 and apply the massive transaction log from that point? Will I be able to use point in time recvory for this transaction log restore? Please let me know.
My maintenance plan stopped running on 3/29 which was creating transaction log backups every three hours and full database backups everyday to disk.