Restoring Transaction Log Backups...
i think i know what's going on, but need to be sure. Thanks for any help here.
we do hourly full backups of our production database. we also have log shipping set up for this database, and do a transaction log backup every 10 minutes. the log shipping has been going for over a year.
a developer asked me to restore to a point in time yesterday, and i saw that we had an hourly backup, plus there were 3 transaction log backups after that. but when i asked SQL Backup to restore to that log backup, the UI took forever and we cancelled the effort.
i believe that there is a transaction log chain for the log shipping backups, and these are not related to the full backups that are done. is this right?
if so, using the log shipping backups to restore to a point in time, is not very useful, or the right way to go.
what does anyone think?