Home Forums SQL Server 2005 Backups Differential Sizes Increase After Index Rebuild RE: Differential Sizes Increase After Index Rebuild

  • May 14, 2013 at 9:14 pm

    #1615264

    JC-3113 (5/14/2013)

    Hi Jeffrey

    thanks for the input

    that takes me back to my original issue

    I am rebuilding indexes on sat night after my full back up

    what happens then is that my differentials are huge because of the rebuild

    (every 4 hours)

    so i was going to rebuild the indexes before the full to alleviate the size of the differentials that follow..

    Jim

    As lynn says it wont allow point in time recovery why not switching it to only Log backup and keep your full backup after index rebuild.

    This is just my suggestion.

    Regards
    Durai Nagarajan