I have a database which grow to 20 GB, after archiving some data, the real size of tables is just 5GB. Backup script does save a copy of the backup to a different location. Moving 20GB or 5Gb does make a difference, so I would like to reduce the physical size, but everywhere I read to do not shrink if I don't want to affect performance.
But it this case of (periodically/quarterly/annually) archiving, is it still recommended not to shrink?
Aucun commentaire:
Enregistrer un commentaire