SQL Server 2014 and 2016, standard edition:
How do I get sqllogship.exe to use built in sql server encryption when backing up and restoring log? (as part of minute to minute log shipping)
Sql-server – sqllogship.exe – how to get it to encrypt log file when backing up log on source server
log-shippingsql server
Related Question
- Sql-server – SQL Server: Understanding log ship utility: sqllogship.exe
- Sql-server – Sql server sqllogship.exe…full docs and/or source code
- SQL Server 2012 – Cannot Use File Server for Log Shipping
- SQL Server Log Shipping from 2014 to 2016 – How to Guide
- Sql-server – Log shipping from SQL Server 2014 Enterprise db to SQL Server 2017 Standard with partitioning
- Sql-server – Why are the Log Ship Jobs Blocking Each Other
- Sql-server – How to Ensure all Log backups are restored on secondary server in log shipping
Best Answer
No way to do this natively through the log shipping GUI or command line with logship.exe
You can roll your own "poor man's log shipping" scenario. Basically all you are doing is backing up, copying, restoring with standby or norecovery and building some alerting.
An older post but an example of what I mean.