Bulk Logged

  • BOL says “the Bulk-Logged Recovery model only allows the database to be recovered to the end of a transaction log backup when the log backup contains bulk changes” But I am able to restore the T-Log that contains purely regular transactions. Am i missing some thing here????

     

    Thanks

     

    Shas3

  • Yes you can. These are completely recorded in the log. Bulk changes are only recorded at a gross level, the page level I think, so you can't recover to an individual transaction there.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply