We have two identical SQL Server 2005 databases. We need to archive data to another server over a network. What would be the best way to accomplish this? This is primarily required because data needs to be archived for at least five years. We don’t need the archive server for backup purposes, just for archiving the data. Please advise what will be the best way to do this.
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!