are there any tables for the website with large amounts of data?
DNN is mostly relying on cascading delete, but it is known not to be very fast, i.e. would need to add further specific deletes to the procedure.

Another important subject is the recovery mode of the database. if you are using full mode (in database properties > options), each deleted record is copied to transaction log, usually simple mode is sufficient for DNN websites (you would be able to restore latest backup but not the changes since in case of a SQL error.

---

Cheers from Germany,
Sebastian Leupold

   

Speed up your DNN Websites with TurboDNN

Another funny thing about the "undeletable" websites is that they are still there and partially functional, meaning that when you call the URL the server shows the site and you can login to them but they are perfectly empty. The menus are there, but the contents are gone and if I try to uninstall modules from them I simply can and the browser loads an empty page. They are ghost portals... kinda spooky. 

Moreover in the Host Site management pane the ghost portals continue to appear. I tried to delete one by deleting the corresponding item in the PortalAlias table of the DB but the item keeps showing up but without an alias. Wonder where the Host -> Site management pane gets its values from. Tried to put things back as they were but failed since I can't remember and most of all can't edit the PortalAliasID cell. Is this real bad? Is there a script somewhere that looks for useless clutter in all standard tables where PortalID = the ID of the portal I want to get rid of?

Thanks

Thanks Sebastian,

managed to truncate my Event Log and Exceptions with your script.

Still have a hard time with the undeletable portals and the clutter left over in my DB.

Is there some kind of script I could use to declutter my database after portal deletion?