Requires iOS 6
MediaExport is an app that allows to export pictures, videos and sounds archived in the MobileSMS app, received either from MMS or iMessage. Did you forget to save the attachment you received a month ago?
Scrolling all messages until you get the missed file can be tedious, just download this app and you are ready to go.
This is for iPhone and iPod touch only.