Hiiiiii
I want to sync Datbases to secondary server which is used for Read-only for SSRS purpose,
these sync can be done once or twice during nightly and mid morning,
Sync database size would be 400 Gb ,50 GB 60 GB
What are my options to approach these scenario
I planned to implement logshipping by using redgate so my backup would be compressed and easier to implement,but i am not sure how to maintain the logfile size for maintenace purpose like when to shrink logfiles because it may grow enoromus untill i take log backup in the night.
or
there are any other options like mirroring or replication please advice me on these
Thank you.