Hi everyone, As the title says, I’ve made a serious mistake with my database. I created a button that runs DELETE FROM {Bills}, and now I’m running into issues with other tables. I tried to roll back in Service Center, but I couldn’t. Is there any way to fix this situation or recover the deleted data? Please help me I’d really appreciate it. Thanks in advance!
Hello,
As far as I know, it is not possible to recover the deleted records, especially if the operation was executed through a direct query. In this case, the data has been permanently removed, unlike a soft delete where an attribute such as IsDeleted is updated.
What you can do is contact the database administrator to check whether a backup exists, or see if there is a backup or audit table that could be used to restore the data.
P.S.: We all make mistakes, so take it easy. Every issue has a solution, even if it’s not a direct one.
Hello.
OutSystems only manages the application.
Like Sherif said, the only to restore the data is if you have a backup of the database. If it is on-premises, your DBA. It it is on the cloud, OutSystems Support.
If it is Personal Edition/Environment, there are no warranties.
Like @Nuno Reis mentioned about 3 scenarios. If its on the cloud, by default there are the daily backup running in the background unless its turned off. Therefore, you can check with guys, who are managing your cloud services