Hi!
@ present we have a reporting server which is for internal and external users..they run regular reports.
- we keep the data in this server for 1 year
- want to avoid the load onto this server,
- server is in 2008 r2 environment
Needs:
- I want o keep the data longer than 1 year
- i can configure another SQL server with 2016
- I can dedicate this for reporting purposes
_ Please advise How this is possible, Guidance is highly appreciated,
Regards,
Bubby
Not really enough detail here. What advice, specifically, are you hoping for?
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.