i am baffled... i just deleted 169 transactions, 1215 targets and 104 names in QB. rather then going down, my file size increased by 5.1mb... wth?
when you delete that does not necessarily mean gone
make a current back and then from the file menu, create a portable file, save it
then open restore the portable file, sometimes that works for what you want
Deleting transactions marks them as deleted within the database, but the file does not get smaller (though that space within the file can be used again later for other data.)
It also adds the history to the audit trail, which can grow the file.
thanks for the idea, it gave me hope which lasted until the portable restore was completed lol. the portable file size was about 15% of the original. but the restored company file is 500kb bigger then the original...
something is very wrong with this company file. we only have about 1300 names but the file size is 367mb. it doesnt make sense to me.
i have to find a way to shrink it because i think its corrupt somehow. thus the deleting of stuff yesterday.
i will try today the condensing data option as a last resort to see if that helps.
n.b.: after the deletions yesterday and file increase, i closed it. this morning i found the file size smaller then it was yesterday but exactly the same as it was before i started deleting. attached is a screenshot - top is before i started deleting yesterday, bottom is today.
Hello there, @tilos1.
Thanks for reaching out to us here in the Community. Allow me to step in for a moment and share some information about deleting transactions in QuickBooks Desktop (QBDT).
Our Top Contributors @Rustler and @BRC are both correct. But if you want to reduce the size of your company file, you can condense your file using the Condense Data utility. Please note that this might be an option, but it is not recommended.
Before you start condensing the company file, you can run a report to see the logic of how and what the program uses to determine which transactions it will not condense.
To run the report:
1. Click the File menu at the top.
2. Select Utilities on the drop-down, then Condense Data.
3. In the first window of the wizard, select Transactions before a specific date then enter the appropriate date.
4. Put a checkmark in the checkbox labeled: Optional: Create a report showing which transactions cannot be removed.
5. Choose Next, then Summarize inventory transactions (recommended).
6. Select how your inventory will be Condensed, then select Next.
7. Then click the transaction groups you wish to be removed, then Next.
8. Choose Begin Condense. QuickBooks does not start Condensing but only runs the report.
Now, here's how to Condense your company file:
1. Go back to the first and second step that I've provided above.
2. Go through the wizard and select the options you need. Select Help if assistance is required.
3. Select Begin Condense. Before Condensing starts, QuickBooks will create a backup and an archive copy.
For your reference, you can check out this article for further guidance through the process: Use the Condense Data utility.
That's it! Please let me know how it goes after performing the Condense Utility. Don't hesitate to leave a comment if you have additional questions or I can be of further assistance. Wishing your organization and yourself continued success.
thank you. if it is not recommended to condense than how can i address the file size. does it make sense that the file with now 1313 names (the total of all items from the list information box-accounts, names, items, classes, etc- is 2776; well under the limit) is currently 373mb? doesnt that mean that the file is corrupt?
Hey there, @tilos1.
Allow me to step in and offer some additional insight into this. Your company file, at 373mb, is well within a normal file size. When it comes to size, it is recommended that your file should not exceed 1.5gb. This is because of the Auto Data Recovery (.adr) file. Being a failsafe, this was put in place to automatically back your data up every twelve hours, holding two constant backups: one from 12 hours ago, and one from 24. In the event your actual working database has become too severely damaged, a .adr file can be used to try and salvage data. So you're good to go as far as the database size is concerned.
Note: for more information on the .adr file, take a look here: Understanding QuickBooks Auto Data Recovery.
However, if your file is corrupted, you have a few data damage troubleshooting tools at your disposal; the Rebuild and Verify Data utilities. What they do is comb through your company file, fix minor data damage, and notify you of anything that needs to be manually resolved. Here's how to run said utilities:
Run the Rebuild Data utility:
Run the Verify Data utility:
For your reference, here is an article that can help you further with troubleshooting potential data corruption: Resolve data damage on your company file.
Once you're finished running the diagnostics, your company file should have a clean bill of health. In the event there are still errors in the file, feel free to reach out to me with any questions you may have about this or anything else QuickBooks. It's my goal to make sure you're completely taken care of and all of your concerns are addressed. I'll be here in the Community if you need anything else.
thank you for the information. i have seen before that after about 150mb for desktop pro company files start to deteriorate thus my concern.
i have done both verify and rebuild data and no change.
another thing - i do see currently that there are 3997 DB File Fragments. there were 4 when I started deleting unused accounts, names, customer messages (someone in the past used that field completely wrong so we have 500+ of those) etc. last week. i understand that the increase in fragmentation is likely because the items i deleted but im not sure what to do about that. any advice?
Hello again, @tilos1.
Thank you for getting back to me on this. To address your concern about the DB file fragments, @Rustler was on the right track with his recommendation of creating and restoring a portable copy of your file. When doing this, it copies and compresses the data, and when you restore the portable file, it re-indexes your file to remove the fragments. I see that you created and restored a portable file before, however, to make sure you're successful in resolving this, I've outlined steps for you down below:
After the data is restored, check the product information screen. You should see a stark reduction in the number of fragments. For your reference, I'm including the article on creating and restoring portable files and why it's beneficial: Create or restore a QuickBooks portable company file.
I want to make sure you're successful in doing this, so please be sure to keep me updated with your progress. Should you have any questions about this, feel free to reach out to me again here in the Community. I look forward to hearing from you.
thank you @ClayJ!
i did follow the instructions precisely and got a portable file (64mb).
after restoring the new company file, while still 373mb, at least it has only 2 file fragments now so it worked as you reccommended.
i am still interested in reducing the size. before i try anything else, is that at all possible? so far my experience is that even if delete the size goes up. that was explained by adding to the audit trail (does it have to? can the audit trail be disabled?).
if it is possible, is there a way to find out how the data is distributed so i know what (old estimates, invoices, vendors, etc) is worth spending the time to delete?
I'm glad to hear everything went well with my recommendation, @tilos1. In order to reduce the size of the file, you have the option of using the Condense Data Utility. Earlier my colleague @FritzF advised of this, but as they also mentioned, we do not recommend using it. The reason for this is that it can cause data damage within the file like transaction linking or missing names list errors.
In the event someone wants to reduce their file size, my go-to is to start a new company file. The good news is, if you decide to go down this route, you have a plethora of resources at your disposal for making the transition much easier on you, and I will be here every step of the way to help you.
For your reference, here are some of those articles:
Should you decide to go through with either of these options or if you have additional questions you'd like to address, feel free to seek me out here in the Community. I'm always happy to help.