2

We have a CommVault server taking log 15-minutely log backups of our primary (on-premise) DBs (combined with full nightlies), for point-in-time restores.

We want to enable high availability for DR fail-over to a cloud-based SQL Instance and we will be using either Log Shipping or Availability Groups.

This secondary instance will be truly passive so as not to incur additional licensing costs (i.e. we will not be able to take backups from it)

We are using SQL Server 2017 Standard Edition and, again for licensing cost reasons, won't be upgrading to Enterprise.

My question is - can CommVault continue to take its log backups for reliable point-in-time recovery and at the same time that either of the high availability options is enabled, or is there a risk of interference?

asked Oct 30, 2019 at 13:28

2 Answers 2

3

can CommVault continue to take its log backups for reliable point-in-time recovery and at the same time that either of the high availability options is enabled, or is there a risk of interference?

You can only have one log chain, so Log Shipping and your CommVault log backups will conflict. Log Shipping can co-exist with full/differential backups, and with VSS backups, but not Log Backups.

An Availability Group replica is maintained by replicating the log records over the network, not through Log Backups. So that can co-exist with your existing backup strategy.

answered Oct 30, 2019 at 13:32
2

Log Shipping is taking Log Backups as part of its process, so you don't want another process doing them as well. Just have Commvault pick up those files that the LS_Backup job created.

Standard edition 2017 is limited to one DB for AG...not even sure if you can have an on-prem and cloud for the nodes. If your RPO allows it, for this case Log Shipping is probably the simpler option for pure DR.

answered Oct 30, 2019 at 13:34
2
  • Thanks @Kevin3NF - I've been trying to find documentation for CommVault that explains how I can get it to pick up the Log Files for Log Shipping and I can't find it. Are you sure this is possible? Commented Oct 31, 2019 at 8:14
  • When I say pick them up, its just CommVault backing up the .trn files created by the LS job. Just files on a drive somewhere... Commented Oct 31, 2019 at 11:41

Your Answer

Draft saved
Draft discarded

Sign up or log in

Sign up using Google
Sign up using Email and Password

Post as a guest

Required, but never shown

Post as a guest

Required, but never shown

By clicking "Post Your Answer", you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.