[SalesForce] How to remove deleted records from salesforce database memory

3 days back I have created a report in my org and after some times I deleted that record ..even i deleted report from recycle bin as well

Now it's been 3 days still that report present in salesforce database

when query with all rows in execute anonymous, soql returning report details

enter image description here

check the created date and it is deleted but still this is in memory..

A way tried by myself. I created 25 K Account records and deleted those records, also deleted from recycle bin

I thought hope this may delete my reports from salesforce database but no 🙁 this report is still in memory..

Looks like I need to wait till 15 days to remove from back end database.

because of this I am unable to create another report with same unique name.

I know if I change the report name it will work but in my case I need to create report with same unique name because of lightning badge 🙁

Best Answer

Even if you delete records from the Recycle bin they still persist in the database for an indeterminate amount of time. Salesforce says 15 days, but I have seen records stay in for much longer than that.

I had an issue with one of our clients at a previous employer around this exact issue. After weeks of being on the phone with the client and Salesforce the issue finally escalated to tier 3 support.

How the delete process works (from tier 3 support):

Each Salesforce instance has a 'sweeper' thread that goes through the database(s) and removes records from tables that are in a deleted status. There is no first deleted first removed to this process. So records can remain on the table long after you have deleted and removed them from the recycle bin.

If you need to get something hard deleted Saleseforce can do that for you if you have the proper level of support. But speaking from experience, it can take quite a while to get to the level of support that can do that for you.

I know this probably isn't the answer you are looking for, but figured I would share my experience with this.

Related Topic