Tried finding anything as weird as I am trying to do on mailing list but couldn't. The idea is to save a copy of the messages on database. 

MSILO module can keep the message as long as the destination user is offline, or doesn't support method:MESSAGE or expiry timeout.

Any ideas will be appreciated.

Best Regards,

Sammy