Re-using generated restore.xml

Last post 10-25-2020, 9:21 PM by Dio L. 5 replies.
Sort Posts: Previous Next
  • Re-using generated restore.xml
    Posted: 10-21-2020, 9:08 PM

    Hi,

     

    Our DBA team is considering to expose a database self-serve restore option to teams who frequently need to perform restores. We currently use the commvault CLI to interface with our automation tools. 

     

    Looking through the manuals the way to go seems to be using 'qoperation execute' paired with a restore.xml file.

    I can't find any way to dynamically generate a restore.xml through a CLI, so I've generated multiple restore.xml through the commcell console with different point-in-time values and did a compare between them.

    The comparison seems to show that only the <pointInTime>  <timeValue> has changed.

    All the <device> details stayed the same.

     

    So provided that there is no removal or addition of MS SQL Server Data Files, would it be safe to assume that the generated restore.xml is reusable?

  • Re: Re-using generated restore.xml
    Posted: 10-22-2020, 8:15 AM

    Hi Dio,

    assuming you used the save as script option here then yes you can re-use the xml


    Gary Seibak
    Technical Account Manager - Commvault
  • Re: Re-using generated restore.xml
    Posted: 10-22-2020, 8:39 AM

    Dio,

    may also want to have a look here - https://documentation.commvault.com/commvault/v11/article?p=18366.htm


    Gary Seibak
    Technical Account Manager - Commvault
  • Re: Re-using generated restore.xml
    Posted: 10-22-2020, 10:50 AM

    yes. it is reusable. And you can override only the values you want to change by including the name of the xml tag and the new value. E.g -pointInTime/timeValue 123456

  • Re: Re-using generated restore.xml
    Posted: 10-25-2020, 7:52 PM

    As the other guys have said they are re-usable and you can override the XML values with arguments in the CLI, but the method of changing DB name, file paths etc does become somewhat cumbersome if needed. 

    If you're automating the same restore with minimal changes then it should be fine, but if it's just self-serve/ad-hoc restore you're into, then why not check out the SSMS plug-in: https://documentation.commvault.com/commvault/v11/article?p=18300.htm

    This will allow you to run per DB backup/restore operations from SQL Server Management Studio (which I assume your DBAs are already using).


    David

  • Re: Re-using generated restore.xml
    Posted: 10-25-2020, 9:21 PM

    Cheers guys! this will give us confidence to proceed.

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