ibdata1 file is 900GB how do i make it smaller

SUGGESTED

The ibdata1 date file is growing very large and seems to keep running - any ideas on how to stop it and reduce it

  • 0
    SUGGESTED

    Hi  ,

    Thanks for reaching out. Our guide on managing and clearing old data from Sage 50 Canadian Edition might be exactly what you need. Please proceed with caution and ensure you create a backup of your data before attempting any changes, as once data is cleared, it cannot be retrieved.

    Here’s a brief overview of steps you might find useful:

    1. Create a backup of your data. This is crucial before making any changes to ensure you don't lose important information.
    2. You can clear several types of data that may no longer be necessary, such as paid vendor and customer transactions, account reconciliation details, deposit slips, etc. Clearing these out might significantly reduce your database size.
    3. There are two methods for clearing data:
      • Manually: Access this through the Maintenance menu in the Home window, select Clear Data, and then choose the type of data you want to clear.
      • Automatically: Set up Sage 50 Accounting to clear data automatically at fiscal year-end via the same menu.

    For detailed instructions on how to proceed with these steps, including how to create a backup, please refer to the full article here: How do I clear my old data?

    Remember, it's essential to proceed with caution and consider seeking assistance from a qualified Sage business partner or support analyst if you're unsure about any step.

    Warm Regards,
    Erzsi