Your prompt
Set up daily database backups and weekly full backups stored off the server, keep 14 days, then restore last night’s backup on staging and confirm it works.
What this prompt does
This prompt asks your AI assistant to schedule daily database backups and weekly full backups, store them off the server, keep 14 days, then restore last night’s backup on staging and confirm it works.
Splitting database and full backups makes sense because a database changes more often than your files. Off-server storage guards against losing both together.
Wording like keep 14 days means older copies are deleted automatically. That saves space, but it also means a problem you notice after two weeks cannot be rolled back, so set the retention to match how quickly you would notice trouble.
The point of restoring on staging, not on live, is that you can fail safely. If the restore breaks, you have lost nothing, and you have learned which part of the process needs attention.
Before you run it
- Pick a backup tool and a remote destination you control.
- Have a staging site ready for the test restore.
- Check storage space for 14 days of copies.
- Keep credentials for the remote storage private.
- Check whether your host already makes backups. They are useful as an extra layer, but do not rely on them alone.
- Pick an hour of low traffic for the scheduled runs, since backups can slow a busy site while they work.
What to check afterwards
- See the schedule in the tool.
- Open remote storage and confirm files arrive.
- Check old backups are removed after 14 days.
- Check the staging site fully.
- Note the restore steps.
- Confirm the restore used last night’s file, by looking at the date shown in the backup tool.
- Check the database backup is small and the full backup larger, which is what you would expect from the split.
Ways to adapt it
- Retention: “Keep 30 days instead.”
- Alerts: “Email me if a backup fails.”
- Frequency: “Run the database backup twice a day.”
- Add a test: “After the restore, compare the post count on staging with live.”
- Add a note: “Write down which credentials and steps a restore needs, without printing any passwords.”
If it goes wrong
- Backups fail on large sites. Check time limits and storage.
- Staging restore shows missing media. Confirm the full backup includes uploads.
- Remote storage rejects uploads. Recheck permissions.
- The backups run but the schedule is wrong. Ask the assistant to read the schedule back to you and confirm the times and time zone.
- Remote uploads work but restores need a plugin that is not installed on staging. Install the same tool there first.
Our backup plugins guide and UpdraftPlus alternatives help you choose a tool, and the backup routine tutorial explains the habit.