We have full backups running every Sunday. Differential every day. Log backups every hour. This is all configured as part of our recovery strategy.
I have been requested to configure log shipping on one of the databases so as to place the db syncronized into the secondary server (read only) for reporting purpose.
Since the log shipping works by taking log backups and shipping then to the other sql server via file share, and my understanding is that a log backup usually truncates the log (unless it is taken with copy only mode). So will log backups happening via the log shipping have any negative impact on my recovery strategy?
For example: Am I right to say that log backup taken by my present jobs will have incomplete log backups because the log shipping will have taken log backups truncating the tlog? Or is it that the log shipping log backups are copy only thus not truncating the tlog?