It is a kind of Storage Management system that automatically grooms files by migrating infrequently accessed
data to near-line and offline storage (Optical Drive, DLT etc) on the basis of criteria such as age and size of the file.
Infact, it mainly used for legacy system (Mainframe, RISC based etc) but
Some vendors like veritas, IBM Tivoli and Legato sell such as product (running under windows)but only for
File Sever and Exchange (Veritas Only)
What I actually need is a tool, method or system that can maintain 12 years of Transaction Data Efficient and effectively within SQL Server database.
Do you have an option to HSM ?
Wow, I'm not sure what HSM even does. I may just be slipping a cog can you describe what the product allows you to do?