Backup and restore

hi i have written some code to clean up backup files that users have created after a certain time period. and i'm wondering what kinds of housekeeping i need to do in the db. my thought is that i just need to delete the record in the files table and it's gone, but i'm not sure if that's enough. does anyone have any experience with this kinda thing? any help is appreciated, thx.