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
Do we really face performance issues when we keep data longer than one year ? Was this your understanding OR Was this exactly a requirement ? because there have been many servers built outside with a more than a year / archived old records running without much performance issues....