I am in the testing phase of a project and have to restore a previous version of the site, without an update package applied. The update package adds files and a table that are left behind after restoring the previous version. Both result in errors when accessing the site. For removal of the table I tried the existing tables "Drop All" in the database restoration advanced options. This fails because there are some database constraints in place that prevent it. I have no clue how to remove the files that cause errors when left behind.
Is there any way to solve this, without having to ask the testers to manually remove everything before restoration?