Hi guys! I was deleting some columns when I accidentally clicked the button to delete the entire table instead. Could someone please help? This is on a production app with a few thousand users.
The App ID is 4E54F8C8-0A73-E26C-FFCB-5C6E36D78C00
The table name is “Appointments”
Thanks in advance!
Hello @Jeffrey_Sera!
I’m sorry about the situation, but you will have to pay $200 for an engineer’s time in order to restore the data.
This amount will be charged to the credit card linked to your account.
Please let me know if you would like us to proceed.
Regards,
Alexander
Hi @Alexander_Pavelko! Thanks for your reply. Instead of restoring the table and integrating it to the current state of our database, would it be possible to just entirely restore one of the backups of our database? Say, from 7 Feb 2022 00:00:00 GMT+0? Would this be easier/cheaper?
@Jeffrey_Sera, yes, we can restore the database completely, but unfortunately, it cannot be cheaper because it will take the same amount of time.
Which option suits you best?
Regards,
Alexander
I see, in that case I would take the entire database restoration. Do you know the time of the latest backup before the table got deleted?
@Alexander_Pavelko It was almost 12 hours ago now. So the backup should be from before 2AM GMT+0 today.
@Alexander_Pavelko I think a backup from 1AM GMT +0 would be good, just to be on the safe side. Thanks!
@Jeffrey_Sera, the Appointment table was deleted at 02:10, and we can restore the copy made at 02:00.
Is this option right for you?
Regards,
Alexander
Sure, that works too! Thank you!
@Jeffrey_Sera, we have started the data recovery.
We’ll let you know as soon as it’s ready.
Regards,
Alexander
@Jeffrey_Sera, I am happy to tell you that the database has been restored.
Could you please check and make sure everything is ok?
Regards,
Alexander
Looking good @Alexander_Pavelko! I’ve taken a look and everything is fully restored. Appreciate your help! I have a follow up question now. As I hopefully don’t want to make the same mistake again (this is the second time), is there any way to either:
a. Edit my own (owner) permissions to remove table deletion as a permission
b. Protect all the current existing tables (or make them default like the Users table, aka undeletable)
Either of the above done from my end or yours… I doubt I will need to delete any of the current tables, so it would be great if they are undeletable (by me) altogether.
We made a change where you will have to manually type in DELETE to confirm table deletion. This will hit the production deployment in the next week or so.
Regards,
Mark
Really appreciate that Mark. I am sure that will definitely help reduce the amount of accidental deletions!