2 of 2 people found this helpful
I'll give you some suggestions
I have a pair of tools that might be able to help you
The first tool will give you a nice graphical interface to determine where the space in your db is currently being used...you can use that tool for identification purposes
The second tool will allow you to setup a number of select statements that will be used to identify records you want to remove from forms, and then remove those records in a quick and efficient way.
Once you have identified the records to remove, and actually removed them....your DB will be absolutely NO SMALLER than it was before, because deleting data out of a db doesn't automatically cause it to shrink....so, after you have cleared out all of the space, you'll need to work with your DBA to get them to shrink all of the empty space out of your DB.
Once you've performed the above, you'll have a smaller db, and if you save the config file for DeleteRequests, you can use it any time you want after you do a DB refresh without the need to re-create the entire effort.
Thanks for replying so quickly.
What you have suggested looks very exciting. I will start working on this right off the bat!
Another Option is to truncate B Tables.
I assume you do not need attachment on Dev/QA Boxes so you can truncate B Tables corresponding the Worklogs. It can help you freeup a lot of space.