What is the maximum retention time does Nimsoft support(in terms of days or years)?
I don't know if this is documented anywhere, but I can't see why it should be anything other than what is max for integer.
It seems that SQL Server has a limit of 1000 days, please refer to the article below:
The 900 day limit is only checked if the state is ‘partition’ (i.e., partitioning is enabled).
Retrieving data ...