• 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,