lundi 9 février 2015

shrink after archiving, is this that bad too?


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