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.
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
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
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
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.