Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.
Sign up to join this community
We have about 20 databases, with no DR config yet. Most of them are SQL Server 2016 with Failover cluster Availability group
What's the best method for a log shipping?
Imo, 2 is much more risks in case of file share server are accessed by someone else.
I supposing you are using Alwayson AG with a SQL server enterprise edition (because you are in a business critical production environment). Why don't you add the DR instance as a node of the alwayson AG cluster? It's free and included in the license you already own.
Instead if you are using basic availability group, you are limited to one copy. So you have to look up for something like log shipping.
Log shipping is based on a share that plays as a repository for tlog backup between primary and distare recovery site.
After saying that, you have to evaluate that the source environment is composed by two nodes that have to use the same repository for LS tlog backups. So a network path is more friendly and reliable.
The risk of having someone to disrupt the share you created is something you have to handle with security and rights in your environment; it should not prevent smart architectural choises.
