Post reply

Minimally logged operations

  • October 19, 2005 at 10:13 am

    #89696

    From BOL: for Bulk Logged Recovery (minimally logged)-  writetext and updatetext; for Writetext- nonlogged for bulk logged. What is correct for writetext and updatetext- nonlogged or minimally logged for bulk logged recovery? Thanks 

     

  • October 19, 2005 at 10:17 am

    #598368

    only minimally logged (about the command, not individual changes)

    In addition, 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. Point-in-time recovery is not supported.

  • October 19, 2005 at 10:21 am

    #598375

    Thanks. Actually I thought the same way

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

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