Hello,
All conversations and messages are stored in the Conversation table [sys_cs_conversation] and Conversation Messages table [sys_cs_message]. There is no archiving or something on these tables. Out-of-the-box these tables are ACL protected.
For checking the notifications that are sent to the agents please have a look at the link below:
Set up a notification in workspace
