- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎May 29, 2023 11:27 AM
Hey All
I have a business producing about 10 000 records a month, that's going to double in a few months. Will it be feasible to create a new base each month and move the previous months data to a "backup" base?
Thanks in advance!
Solved! Go to Solution.
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎May 29, 2023 05:22 PM
Yup. One of my old clients has been doing this for a few years.
When you duplicate the base, name the duplicate to with the name of the previous month. This duplicate is your "backup". I also like to change the color and/or icon of the duplicate base in order to quickly tell that it is an old base. I also usually put the duplicate in a free "archive" workspace.
Then in the original base, delete the old month's records. If you need to delete a lot of records in multiple tables, you can use a script to delete them quickly.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎May 29, 2023 03:44 PM
Yes, this can be done. You'll likely require a Pro plan which allows 50,000 records per base while the Plus plan is limited to 5,000 records per base. Bases can be easily duplicated/archived.
Check out record limits and other details here: https://support.airtable.com/docs/airtable-plans

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎May 29, 2023 05:22 PM
Yup. One of my old clients has been doing this for a few years.
When you duplicate the base, name the duplicate to with the name of the previous month. This duplicate is your "backup". I also like to change the color and/or icon of the duplicate base in order to quickly tell that it is an old base. I also usually put the duplicate in a free "archive" workspace.
Then in the original base, delete the old month's records. If you need to delete a lot of records in multiple tables, you can use a script to delete them quickly.
