Best Practice: Deleting records but not customizations

You'd typically want to preserve the following tables:

acl*

team*

fields_meta_data

relationships

users*

workflow*

pmse*

schedulers

config

There is an off chance that a specific type of customization requires data from another table, such as dashboards, but the above list should contain the vast majority of the customization related data.

It would likely be safer to identify the tables related to the modules containing data you wish to purge and then focus on deleting that data. 

Kristjan Geir Mathiesen, list out modules from which you want to delete data, go to database and truncate tables with data but exclude above listed tables by Angel Magana.

Other thing you can do is, delete records from CRM and then run prune database scheduler, so that backup copy will also be created in cache or upload...and database will be clean.

http://support.sugarcrm.com/Documentation/Sugar_Versions/7.6/Ent/Administration_Guide/System/Schedulers/#Prune_Database_on_1st_of_Month

Hope this will help you.

Hi Kristjan! So glad the Sugar community is able to support you. If you're looking for other ways to improve your Sugar instance we've got the event for you. We'll cover user adoption, security and optimization and give attendees worksheets to complete their own CRM assessment. More on our free, online workshop: http://ow.ly/ZpD4305yCzO