How to show all the attachment stores in use by Archive Manager
Run the following SQL query in SQL Management Studio on the Archive Manager SQL server:
USE ArchiveManager
SELECT RIGHT(s.connectionstring,LEN(s.connectionstring)-5) + '\' AS AttachmentStores, [default] AS IsDefaultAttachmentStore FROM storagelocation AS S
