Post reply

Differential Sizes Increase After Index Rebuild

  • May 14, 2013 at 2:28 pm

    #1615200

    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

    This is a decision you have to make, we can't make it for you. If you are rebuilding every index on Saturday night, then you may want to run a differential prior to the rebuilds (gives you a restart point if there is a problem during the rebuilds) and then a full backup when they are completed.

    This has to be your decision and you have to support it to your boss.

  • 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

  • May 15, 2013 at 9:04 am

    #1615481

    Thanks Lynn

    Jim

  • May 16, 2013 at 12:12 am

    #1615616

    The best way to save backup space would be to rebuild your indexes before the full backup.

  • May 16, 2013 at 7:47 pm

    #1616031

    Thanks Simon

    Jim

Viewing 5 posts - 16 through 19 (of 19 total)

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