Can I recover accidentally deleted data base schema?

Avatar

Avatar

poorvab56881543

Avatar

poorvab56881543

poorvab56881543

26-04-2018

I accidentally deleted the data base schema folder and all the schemas are deleted.

Is there a way to recover deleted schemas?

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar

Vapsy

Employee

Avatar

Vapsy

Employee

Vapsy
Employee

27-04-2018

Have you tried recreating the folder by right clicking on Configuration and adding the Data schema folder?

1474730_pastedImage_0.png

In my opinion, you cannot delete a schema by deleting the folder.

Just add the folder and it should be back. Give it a try and let us know how it goes

Answers (3)

Answers (3)

Avatar

Avatar

poorvab56881543

Avatar

poorvab56881543

poorvab56881543

02-05-2018

Thanks Vipul! You are right. The schemas do not delete on delete of folder.

Avatar

Avatar

AbdulZa

Avatar

AbdulZa

AbdulZa

26-04-2018

This is my understanding also.

A good practice to generate a backup export to certain Adobe objects frequently (e.g., daily backups which gets overwritten after 7 days).

Avatar

Avatar

shrawans3153003

Employee

Avatar

shrawans3153003

Employee

shrawans3153003
Employee

26-04-2018

The only possible way is to restore deleted schema's from the last available backup with the help of  DBA/Infra support team