OnDemand SQL Server DataBase Backup

Last post 03-20-2017, 2:13 PM by tcottrell. 1 replies.
Sort Posts: Previous Next
  • OnDemand SQL Server DataBase Backup
    Posted: 03-16-2017, 12:31 PM

    Hello,

    We are trying to create a script for SQL DBAs to run, that will backup the transaction logs of a specific database.

    At the Sublcient Level we have 10 databases configured but we only want to run (via script) the backup of one specific DB.

    Is this possible? According docummentation (https://documentation.commvault.com/commvault/v10/article?p=products/sql/cli_backup.htm ) the following command should do it no?

    qoperation execute -af backup_template.xml -backupLevel FULL -subclientName subclient1 -clientName client1 -instanceName client1/instance1 -ondemandinputfile C:\test\myDBsContent.txt

    where myDBsContent.txt is an input file that list the databases.

    We have tryied to do it but it backups all the DBs within the sublcient.

    Its this possible at all?

     

    Regards,

  • Re: OnDemand SQL Server DataBase Backup
    Posted: 03-20-2017, 2:13 PM

    Yes this is possible, however you have to first create the ondemand subclient using these steps:

    https://documentation.commvault.com/commvault/v10/article?p=products/sql/cli_config.htm#Specifying_Databases_for_On_Demand_Backup

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