I have been reading a lot on how to archive data that would only be used for reporting, and I am unclear on exactly what/how I should be archiving.
Use case: I have a collection in the live cluster that cannot have documents removed (Coll1), and I have 2 other collections that could be archived after a period of time (read-only and no need to be in the live cluster). When running reports on the archived data through a federated connection string, can I use a combination of archive data collections and from Coll1 as a lookup?
I am concerned about the data removal portion of archiving process because I will always need the documents in the Coll1 to be updatable and available from the cluster. Maybe there is a better approach I am not aware of?
Thanks!