SQL Backup status - Commserve Table

Last post 09-24-2020, 7:20 AM by ddwyer. 1 replies.
Sort Posts: Previous Next
  • SQL Backup status - Commserve Table
    Posted: 09-22-2020, 2:12 AM

    I would like to know in which table does CS store the details of SQL backups

    Like Status, conversion reason etc. It tried to find  it here :


    but couldnt find the details.


    I want to create a custom alert using that, please help


    Attachment: smaple.png
  • Re: SQL Backup status - Commserve Table
    Posted: 09-24-2020, 7:20 AM

    Hi bumblebee,

    It looks like there is an XML dumped in JMMisc that for itemType = 28 will show you the job failure/conversion reasons.

    The other interesting tables for SQL stuff would be sqlArchiveInfo, sqlDbBackupInfo, sqlNames and sqlNames2.

    I hope this helps you out.


The content of the forums, threads and posts reflects the thoughts and opinions of each author, and does not represent the thoughts, opinions, plans or strategies of Commvault Systems, Inc. ("Commvault") and Commvault undertakes no obligation to update, correct or modify any statements made in this forum. Any and all third party links, statements, comments, or feedback posted to, or otherwise provided by this forum, thread or post are not affiliated with, nor endorsed by, Commvault.
Commvault, Commvault and logo, the “CV” logo, Commvault Systems, Solving Forward, SIM, Singular Information Management, Simpana, Commvault Galaxy, Unified Data Management, QiNetix, Quick Recovery, QR, CommNet, GridStor, Vault Tracker, InnerVault, QuickSnap, QSnap, Recovery Director, CommServe, CommCell, SnapProtect, ROMS, and CommValue, are trademarks or registered trademarks of Commvault Systems, Inc. All other third party brands, products, service names, trademarks, or registered service marks are the property of and used to identify the products or services of their respective owners. All specifications are subject to change without notice.
Copyright © 2020 Commvault | All Rights Reserved. | Legal | Privacy Policy