Hi gurus
We have a system(Database is SQL Server 2000) wherein we want to Archive data every 5 years and would want to keep the data forever. Now the question is, once the data is Archived, will it be available for query. Also, would it be on another server?
I would want to know what is the normal accepted way of Archiving data and at the same time making it available for querying.