My database has MDF datafile 20G bytes, when I backup DB, the backup file = 20G also
After I delete many records, many backup tables in database, the backup file reduce to 10G. I use Shrink database, the LDF file reduces size, but MDF file is still big with 20G. The number of record in DB is reduced but MDF file is not reduced
So how to reduce it?