Deleting large amount of data from Database

  • Hi

    If I have a 2 TB database with 1.5 TB used in the mdf file – If I delete 1 TB of data leaving only 500 GB AND 1.5 TB free in the mdf file.

    1. Would that reduced data in the mdf file make a restore of the database backup quicker to another server any quicker.

    My thinking is that the backup AND restore would be quicker because of emptier data file? Would that also result in a smller backup file too?

  • The backup would certainly be smaller, and thus both backup and restore times would be shorter, but if you just move the physical file across the network, there's no reduction in time at all, because the entire 2 TB file is going across the network, and not just the active data.  Does that help?

    Steve (aka sgmunson) 🙂 🙂 🙂
    Rent Servers for Income (picks and shovels strategy)

  • That does help, thanks.

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

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