Noob SQL query.
Can SQL Transaction log backups be performed using different backup solutions, such as Commvault and native log backup?
We have a customer who performs tlog backups every hour and a daily full backup using SSMS native backup tool (not a copy-only backup).
AppAware is also used to run a full Snapcopy backup of MS SQL on commvault.
The customer has requested that transaction log backups in Commvault be performed every 15 minutes in addition to the hourly native log backups.
My understanding is that if we use separate backup solutions, we might end up with one solution containing one chunk of log backup data and the other containing another chunk of data.
As a result, neither solution has a consistent chain that allows for point-in-time recovery.
Is my understanding correct?
Could someone please suggest the best solution to this?
Should I ask the customer to disable native backups and rely solely on Commvault due to its ease of use in restoring?
Best answer by Scott ReynoldsView original