Database Maintenance in SavePoint

Last edited: November 21, 2026

Database Maintenance in SavePoint

SavePoint stores all your financial data locally on your computer in a database file. Over time, as you add transactions, update balances, and build your financial history, it's good practice to perform occasional maintenance to keep things running smoothly.

Here's what you need to know about keeping your SavePoint database in good shape.

Understanding How SavePoint Stores Your Data

When you use SavePoint, everything lives on your device. Your transactions, account balances, budget settings, and FIRE projections are all stored in a local database file. This is a core part of SavePoint's privacy-first design: your financial data never leaves your computer and never gets transmitted to any servers.

This local storage approach means you have complete control over your data, but it also means you're responsible for maintaining it. The good news is that maintenance is straightforward and doesn't require technical expertise.

💡 Key Point

SavePoint is designed to handle years of financial data without performance issues. Most users won't need to think about database maintenance often, but establishing good habits early helps ensure long-term reliability.

Regular Backup Practices

The most important maintenance task is backing up your data. SavePoint includes built-in backup functionality that you can configure in Settings under Preferences and Local Backup Settings.

Here's a solid backup routine:

Weekly automatic backups: Configure SavePoint to create regular backups to a location you specify. This could be a separate folder on your computer, an external drive, or a folder that syncs to your preferred cloud storage.

Monthly manual backups: Once a month, export a backup and store it somewhere separate from your primary backup location. This gives you redundancy if something happens to your main backup.

Before major changes: Always create a backup before importing large amounts of data, migrating to a new version, or making significant changes to your accounts or budgets.

Keeping Your Data Clean

Over time, you might accumulate data that no longer serves you. SavePoint provides several tools to help you maintain clean, organized records:

Account deactivation versus deletion: When you close a bank account or pay off a loan, consider deactivating the account in SavePoint rather than deleting it. Deactivation preserves your historical data while hiding the account from active views. This is reversible if you need to reference that history later.

Transaction management: If you've imported duplicate transactions or have entries that don't belong, use Edit Mode on the Transactions page to select and remove them. Take care when using bulk delete operations and verify your selections before confirming.

Category consolidation: If you've created more expense categories than you actually need, consider consolidating similar categories. Fewer, broader categories often make budgeting easier and reports more meaningful.

⚠️ Important Warning

Deletion is permanent. When you delete transactions, accounts, or other data, it cannot be recovered unless you restore from a backup. Always back up before performing any cleanup operations.

Performance Optimization

SavePoint is built to handle substantial amounts of financial data efficiently. If you notice the application becoming slow, here are some things to check:

Dashboard modules: If your dashboard feels sluggish, try disabling any modules you don't actively use. You can customize which modules appear through Dashboard Settings.

Report generation: When generating reports that span many years of data, expect some processing time. Consider narrowing the date range if you only need recent information.

Large imports: When importing thousands of transactions at once, the process may take a few moments. Let the import complete fully before navigating away or closing the application.

When Things Go Wrong

If you encounter issues with your SavePoint database, restoring from a backup is usually the fastest solution. Navigate to Settings and use the restore function to return to a previous state.

For persistent problems or unexpected behavior, SavePoint's built-in help system provides troubleshooting guidance. The help button (usually marked with a question mark) on each page offers context-specific documentation.

Staying Current

Keep SavePoint updated to the latest version. Updates often include performance improvements, bug fixes, and new features. Your license includes all minor updates and bug fixes for the purchased version throughout its lifecycle.

Ready to Take Action?

Good database maintenance starts with good backup habits. Take five minutes today to check your backup settings and create a manual backup of your SavePoint data.

View SavePoint Help

For detailed instructions on any SavePoint feature, check the complete user manual available in the application and at savepointfinance.com/help.

Comments (0)

No comments yet

Be the first to comment on this post!