In Local IDC High availability Database mirroring already configured since 5 years back with manual failover with no witness server. Now management decided to configure this DR setup with existing database mirroring setup.
TLOG backup configured every 15 min in principal database for controlling LDF file size growth and point in time recovery
we can 't extent one more 3rd node due to DB mirroring limit and support only tow nodes. And 3rd party vendor application restrictions I can't upgrade higher version SQL 2012 or 2016 for choosing alwayson HA new feature
I need to choose option Log shipping only for fulfill this DR requirement. So I want to know what is the time interval to be setting in TLOG backup setting in Log shipping scenario due to already TLOG backup configured every 15 min in principal database.
So, Can we choose two different timing custom TLOG backup and TLOG backup in log shipping setup
1. Custom TLOG backup at every 30 min
2. Log shipping TLOG backup at every 15 min
Will it cause of LSN chain brake in log shipping if above two backup times? Please suggest.