quote:
Not sure what you're asking; I was trying to specifically answer mail_db's questions.You can apply unbroken chains of tran log backups to a full or differential restore. If the recovery model was set to Full for the entire period covering the last tran log backup you plan to restore, you may perform a point-in-time restore.
A tran log backup chain is broken if a tran log backup is bad or missing, or if the tran log was truncated other than by backing it up (including changing the recovery mode to Simple).
--Jonathan
Thanks for your answer. I'm learning and trying to understand how to use the restore functions. I was very interesting on mail_db's question. It is a case that everyone could face in the future. If the discussion got confusion because my question, I apology for it.