T-Log Backups - Before or After Switching

  • Hi,

    It is important to perform a t-log backup when switching from bulk-logged to full recovery, but does it matter whether you perform it before switching or after switching. Please clarify.

    Thanks,

    Karim

  • This was removed by the editor as SPAM

  • If the recovery model is in bulk mode then the size of the tran log backups will be smaller compare to full especially when log is being dumped during some bulk operations.

    The bulk copy operations are fully logged under the Full Recovery model.

    -Krishnan

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

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