Our Knowledge Base covers a wide variety of technical topics, from the basic to the complex.
Can you tell me how the QuickBase team backs up and restores customer data?
Backups are part of our overall philosophy of high availability (HA) and ease of disaster recovery (DR). All apps in all accounts are backed up daily.
The type of plan or pack chosen by the billing account administrator affects whether apps from that account can be restored. Enterprise plans can request a restore up to four times per year. Other plans can add a “restore pack” to the monthly charges on the account, which allows restore requests four times per year.
We back up every application daily. The encrypted backup files are stored within Intuit-owned data centers. We do not use a third party to maintain backup files.
Local backup for applications is done as a snapshot every 24 hours, and we keep the most recent 14 daily snapshots. In addition to the daily snapshots, we keep the most recent six months’ worth of weekly snapshots past the 14 days’ worth of daily snapshots.
Note: For an application to be recoverable from backup, it must not have been created and deleted within the same day.
Should any user on your account accidentally delete data or an application, you would need to request a restore if you want to retrieve that data. The turnaround time for a restore is typically 3-5 business days, but can be longer in some cases, depending on how far back you need us to go. Keep in mind that the farther back you wish to restore data, the less likely we are to have a backup that will restore the exact data you need.
We offer two types of restores:
This is a full restore where we restore some tables or a whole application as it was on the date it was backed up. In this case, you would lose any changes that have been made since the restore date, so it's your responsibility to export any new data or changes and merge them with the live app once the restore is complete.
We send you a simple QuickBase app containing an Excel file of your data as it was on the date it was backed up. You would then import the file into your existing application. Sending the file in an app helps ensure the data is for your eyes only!
To request a restore, enter a support case and tell us that you need a restore. You will be asked to provide:
the exact date the data was deleted
whether you need to restore file attachments (only available for overwrite restores)
the DBID of the application
what type of restore you want
Maintaining your own backups
Many customers choose to back up their data on a regular basis rather than pay for a restore. If you decide to maintain backups on your own there are several features that will help with this process.
Use the More > Save as a spreadsheet command to save a report into CSV format. This exports the data only, not file attachments.
Make a copy of your application.
Export all tables and attachments using the QuickBase Desktop tool, linked from the article below:
Purchase the QuickBase ODBC driver from QuNect (a QuickBase partner). This tool can be used to sync data between QuickBase and other applications such as Microsoft Access, SQL Server, or Crystal Reports. See http://www.qunect.com/ for details.
Disaster recovery overview
HA/DR RTO of two hours for any unplanned service outage event
HA/DR RPO of ten minutes’ worth of transactions for any unplanned service outage event
100% user and transaction capacity for all HA and DR solutions (no reduction in system capacity)
Geographic separation of DR sites, with independent power and internet connectivity pathways