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?