Restore a backup

There are two backups. Supabase Pro keeps its own daily copy of the database for 7 days. The nightly backup you set up under Settings, System, Connections, Services, on the Backups card, copies every table and every file to a bucket in your own cloud account and keeps it. This page is about bringing that one back.

Before you start

• A restore goes into a fresh copy of the system, never over the one you are using. It refuses a system that already has quotes or orders.
• It is a technical job: it runs a small program that comes with your copy of the code, with your bucket's keys and the new database's key. If you are not comfortable with that, contact support and say which day you want back.
• For a deleted record or two, you do not need a restore. Open Settings, Tools, Trash: anything deleted in the last 60 days is there, with a way back.

What happens

1. A new Supabase project is made and the system installed in it, at the backup's version or later.
2. The restore program makes every login again, with the same people and no passwords.
3. It loads every table from the day you pick, without sending a message, renumbering anything or logging anything twice.
4. It copies every stored file back, such as photos, signed forms and documents.

After the restore

1. Paste your service keys again (maps, texting, email, Stripe and the rest) under Settings, System, Connections, Services. Keys are never in the backup, on purpose.
2. Point your website at the new project, and sign in.
3. Ask everyone to use Forgot password on the sign-in page to set a new password.
4. Open Settings, Tools, Health and check that everything is working.

Good to know

• Each night's set is kept 30 days, and the one from the first of each month is kept forever.
• Files are copied once and kept. A file deleted in the app stays in the backup.
• A night whose set has no finishing list did not complete. Restore an earlier day.
• To check your backups are running, open Settings, Tools, Backups: it shows the last backup with its date and size. Press Back up now for a fresh one. See Backups.