Skip to main content
commvault.com commvault.com
Solved

SQL transaction logs not getting backed up for single DB

  • August 23, 2023
  • 1 reply
  • 548 views
C
Byte
Forum|alt.badge.img+6

​

I was testing a database restore (DB is in full recovery) and noticed that the PITR graph wasn’t showing continuity.

I checked the server and we still had an old logshipping job which was grabbing the logs and backing up to disk before commvault could get them..  We currently use database mirroring which doesn’t have any jobs associated with it.

 

I disabled the job and ran a full database backup from Commvault,  expecting that our default 15 minute log backups would start afterwards, but that doesn’t appear to be the case.  I’ve taken a manual log backup in Commvault, but it’s still not getting picked up by the regular schedule.

 

Any thoughts on how to resolve this?  The default client run completed at 3:01 pm and backed up every log *except* this database, which I had to do manually.

 

Thanks- Chris

​

Best answer by Sujay kumar

Hi @Chris Newman from description it seems to be log shipping might be causing transaction logs backup to skip due to database mirroring config.

please check advanced option if it helps for your query,
https://documentation.commvault.com/2022e/expert/58638_sql_agent_configuration_sql_configuration.html
 

Allow backup for log shipping configured database

Select this check box to back up logs for primary databases in the native log shipping configuration. By default, log backups are skipped for primary databases to avoid LSN chain breakage.

 

View original
Did this answer your question?

1 reply

S
Vaulter
Forum|alt.badge.img+7
  • Sujay kumarVaulter
  • Vaulter
  • 70 replies
  • Answer
  • August 28, 2023

Hi @Chris Newman from description it seems to be log shipping might be causing transaction logs backup to skip due to database mirroring config.

please check advanced option if it helps for your query,
https://documentation.commvault.com/2022e/expert/58638_sql_agent_configuration_sql_configuration.html
 

Allow backup for log shipping configured database

Select this check box to back up logs for primary databases in the native log shipping configuration. By default, log backups are skipped for primary databases to avoid LSN chain breakage.

 

C
1 person likes this
  • C
    Chris Newman

Reply


Most helpful members this week

Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings