Hi All ,
I have a large database with 3 tables each containing about 80 - 90 million records , these tables contain about 5 years of data .
We only need to keep the last 2 years of data only . ( we will keep the old data for later use ).
My question is : What is the best approach for archiving data in SQL Server ?
(SQL Server 2016 )