Our company has a big data server in which large data is stored, like images, video, audio, etc. Our company wants a process running with the new year, such that in 2020 the previous year's 2019 data will be automatically archived and removed tables the live tables. In the future, we'll take a backup of the archived data.
I am new in this field. Which Mechanism should I use for this purpose?