Home Forums SQL Server 2005 Backups The Effect of Reindexing on a backup file RE: The Effect of Reindexing on a backup file

  • Hi Gail,

    Thank you for the speedy reply.

    The reason for the question is because I am having a debate with my EMC backup admins about the unique data the backups present to our Data Domain nightly. I am of the view that once we defrag the indexes and perform the backup again to a file the blocks in the file have moved around, so they will be seen as unique by the data domain which uses deduplication.

    Hope I am making sense.