Comments (2)

  1. Nice Series! Why Backup the tail of the log after you’ve restored the page?
    I would have thought it would make more sense to back the tail of the log before you restore the page?

    1. Hi Paul. In order to bring the file and its filegroup back online, it has to be brought current with the rest of the database. The tail log backup must include all transactions up to the point where you begin the recovery of the file. You can do it before as long as there are no other transactions occurring on the database, but it has to include everything up to the point of the page restore.

Leave a Reply