SQL database verify

Last post 09-24-2020, 7:42 AM by Henke_H. 2 replies.
Sort Posts: Previous Next
  • SQL database verify
    Posted: 09-21-2020, 5:57 AM

    Is there a  way to get a message or an alert where the status of a Sql database state is successfull or not.

     

    I am running a scheduled intellisnap with backup copy and SQL verify and would like to have a state ment on how the SQL verify ended.

    I'm not able to find any token for it, not even a statement in eventlog.

    Only way is to dig into the log files of the actual job and not even there it's 100% clear on the outcome.

     

    Since there is a command sent to the SQL server for DB check, there has to be some sort of result to get from that no?

     

    BR
    Henrik

  • Re: SQL database verify
    Posted: 09-24-2020, 7:32 AM

    Hi Henrik,

    When you say SQL Verify what exactly are you seeing CV doing here?

    Is it doing a snap integrity check or is something running in SQL server at the time of the backup?

    I've not heard of this feature before on backup, there is a verify option on restore which will run a SQL verify only restore? Is this what you are doing in your environment?

    David

  • Re: SQL database verify
    Posted: 09-24-2020, 7:42 AM

    Hello,

    Sorry I thought one thing wrote another.

    It is the Snap integrity I meant.

     

    //Henrik

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.
Close
Copyright © 2020 Commvault | All Rights Reserved. | Legal | Privacy Policy