Skip to main content

Hi Team,

We have enable dish cache for sql backup and log RPO is given 1 hour  and Commit is 4 hours. We can see the committed job but we can’t see log RPO jobs. I would like to know to check sql transaction log backups are backing up to disk cache.  

Hello @Tyson Storage Team 

Thanks for the great great question!
The following states details: 

https://documentation.commvault.com/2022e/expert/disk_caching_for_frequent_log_backups.html
If your current log backup schedule is hourly or several times a day, you can use disk caching of log backups to decrease the load on the CommServe computer. You can run log backups at a greater frequency, in a scalable manner, without adding to the workload of the CommServe computer.


The goal of the cache backups is to take the load away from the CS with extreme frequency of log backups. This means you will not see a job at all in the CS GUI for the log backup to cache. You will only see the backup of the cache its self and this is expected to run less frequent. 

Kind regards

Albert Williams

 


Hi Albert,

Thanks for your reply.

Can we check cache log backups details from MA or client.


Hello @Tyson Storage Team 

You should be able to see the logs in the SQLBackup.log on the client side.

Alternatively you can also check the backup status in the SQL DB its self if you are familiar on that front.

Looking around i found this and it might provide a simpler view of what you are trying to achieve here: 
https://www.mssqltips.com/sqlservertip/1601/script-to-retrieve-sql-server-database-backup-history-and-no-backups/

 

Kind regards

Albert Williams 


Reply