Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB General » View Thread |
Messages 1 to 3 of 3 total |
Backup size changes after Maint.. |
Mon, Feb 1 2021 1:11 AM | Permanent Link |
Ian Branch | Hi Guys,
More a curiosity question than an issue or concern. Due to a Server PC issue a Customer just rebooted his server pc. After he had, he did a backup of his EDB Database.. {code} DBSBackup.Execute('BACKUP DATABASE "DBiWorkflow" AS "DBiWorkflow-Manual Full Backup - ' + FormatDateTime('yyyy-mm-dd @ HHnn', Now) + '" TO STORE "Backups" COMPRESSION 9 INCLUDE CATALOG'); {code} He then did what we call a 'Maint' which consists of.. {code} DBC1.Execute('Repair Table ' + aDataTables[nXt, 0]); {code} then {code} DBC1.Execute('Optimize Table ' + aDataTables[nXt, 0] + ' No Backup Files') {code} on each of the 28 tables in the database. He then did another backup. So here's the curiosity... Backup size before 'Maint' = 1,087,676,207 Bytes. Backup size after 'Maint' = 1,201,478,514 Bytes. Why such a large difference?? Regards, Ian a |
Mon, Feb 1 2021 1:41 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Ian
I'll be interested to hear the answer. My guess is that there was some "corruption". The backup copies what it can "see" in the tables and after repairing it can see more. You might want to add a VERIFY TABLE in as part of the routine a) because if there's no problem don't repair and b) so you have a record of any problems that did exist Roy Lambert |
Mon, Feb 1 2021 3:19 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Ian,
<< He then did another backup. So here's the curiosity... Backup size before 'Maint' = 1,087,676,207 Bytes. Backup size after 'Maint' = 1,201,478,514 Bytes. Why such a large difference?? >> OPTIMIZE TABLE will physically reorganize the table and rebuild the indexes, and this can definitely affect how the compression works. Tim Young Elevate Software www.elevatesoft.com |
This web page was last updated on Sunday, May 19, 2024 at 08:46 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |