We have SQL Server 2012. A service we use requires us to use log shipping, however we are tired of having users being kicked offline every 15 minutes.
Are there any creative ways to get around this (I believe it cannot be stopped) but perhaps setting up replication & log shipping is that possible?
Somehow having two instances of the same database so when one goes down for log shipping the secondary is automatically used.
Just looking for any creative way to get around users being kicked off during log shipping.