The requirement is to make the data in test server same as the live server. This update should happen every week. The test server should hold only last one year data from production.
Please let me know the best possible way to do this.
(Taking backup from live and restore in test is an option. But the requirement is to keep only one year data from production for transaction files due to test server size constraint)