How to determine consumption of data for archiving in sql server?
Analyzing the usage pattern of the server via profiler and/or extended events is going to be the way to go.  Or ask the business unit what data they want archived.  If they say that they don't want any data archived, then the conversation is over.