I am about to embark on a project to convert our custom backup solution to litespeed and I'm looking for any tips, tricks, or gotchas from the community.
Our environment is 50 instances of SQL SERVER 2012, 2014, and 2016, approximately 2000 databases ranging in size from 2GB to 3TB.
We currently and would like to keep the following backup routine.
For Full recovery: Weekly Full, Nightly Diff, T-Log every 15 minutes
For Simple recovery: Weekly Full, Nightly Diff
For Read Only: Currently we do a full any time the database comes out of ReadOnly status or yearly. We'd like to change that to a 1% Change through litespeed and a yearly Full.
I know there are features of litespeed that would allow us to do differentials based on change etc but it will take time to get approval from our auditors so right now it is as straight a changeover as we can do.
Features I am curious about that I plan on using, Writing to 2 locations at once, Maintenance Plans vs Jobs, Object Level Recovery.
Any suggestions on how to do a roll out for an environment our size?
Any other interesting information people have discovered would be appreciated.
Thanks