Here is what we have at present,
SQL Server (ABC) where reports are run,
- I keep 1 year data on this one,
- do not want to keep data more than 1 year due to performance issue
- all reports are run of here at present
Requirements:
- need to have data available more than 1 year
- want to create new server,
- want to export the data copies to this new server using ....please suggest best practice
Help is highly appreciated,
Thanks,