- 23 Aug 2023
- 3 Minutes to read
Taking and restoring base snapshots
- Updated on 23 Aug 2023
- 3 Minutes to read
Using a base snapshot, you can back up a base and restore it to an earlier version. Airtable automatically takes occasional snapshots of your bases, and you can also manually take a snapshot. It may be a good idea to manually take a snapshot of your base immediately before restructuring or otherwise making a large number of changes to your base. All base collaborators are able to take and restore from a base's snapshots.
|Plan availability||All plans with varying limits|
Editor permissions or higher are needed in the base where you want to take a snapshot
|Platform(s)||Web/Browser, Mac app, and Windows app|
How to take a snapshot
Airtable will automatically take snapshots of your bases at set intervals (after a certain amount of data is entered), but you can also manually take a snapshot.
Taking a snapshot won't affect the base you create it in. Restoring a base from a snapshot will create a new base without affecting your existing base. The new base created by a snapshot can be used as a reference for recovery purposes, or you can switch over to this base completely moving forward. Bases restored from snapshots do not have revision history but will include record comments.
To manually take a snapshot:
- Open the base history menu (which resembles a clock running backwards in time), and click the Snapshots option:
- Then, select the "Take a snapshot" option:
- It may take a few seconds for your snapshot to complete. A message will appear. Click Okay.
- Once it has been completed, it will show up in the snapshots menu. Depending upon the workspace plan, snapshots are stored for different periods of time. Learn more below.
How to restore a base snapshot
To restore a snapshot:
- Click the base history icon, then snapshots, then choose the snapshot you'd like to restore:
- You will then be prompted to select a workspace into which to place the restored snapshot of your base.
- This is a reminder that snapshots are a previous version of the base. Since other changes may have occurred since the snapshot was taken, Airtable creates a new base in the workspace of your choice. We do not overwrite the current version of the base.
Limits on snapshot history
Your snapshots won't stick around forever—snapshots are only accessible for a certain amount of time depending on your workspace's pricing plan.
- Free plan - Able to see the past 2 weeks' worth of snapshot history.
- Team plan - 1 year's worth of snapshot history will be saved starting at your time of upgrade.
- Business plan - 2 years' worth of snapshot history will be saved starting at your time of upgrade.
- Enterprise plans - 3 years' worth of snapshot history will be saved starting at your time of upgrade.
Snapshots have no revision history -- but comments are retained from the source base, like any other data.
The exact scheduling of snapshots is based on the count of user actions taken in a base. On a base that's very actively used, you'll probably get at least one snapshot a day. For bases not used as frequently, snapshot cadence will adjust accordingly. You can get a sense of the regularity around which you can expect snapshots to be taken, presuming usage levels remain steady, by viewing your current snapshot intervals after a few days of using your base at a typical rate.
If you take a base snapshot manually, you'll need to wait for a little while before you can take another. This time period is typically just a few hours, but can vary depending on how many changes are made in your base since that last snapshot was taken.
Yes! Base snapshots do include interfaces, and any edits currently pending on those interfaces.