We've got a list from app owners to restore say 20 databases from a total of 100 available production server databases onto a test server on weekly basis.
Moreover, they require it in a way that backup that would be occurring should contain data of last 60-90 days for all the above 20 databases.
I am not sure if that can be achieved. If yes, kindly give suggestions how can I go around this to automate the backups as said above.
For automating the restore process, should I go with Log Shipping or Transactional replication? We have space issues on test and the client does not want to invest much!