How to tell is a specific archive contains items that are on legal hold
I need to change the policy and retention for an FSA archive and was planing on deleting the old archive then re-archive the data after the change. I wanted to know if there was a way to know if the archive contained any legal hold items. Since legal hold data cannot be deleted I will need to rename the old archive and just have two archives for the file server. I am guessing there is a way in SQL, but am not sure.