March 8, 2018 at 7:33 am
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?
March 8, 2018 at 8:21 am
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)
March 8, 2018 at 10:36 am
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