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)
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!