we have many SQL servers which has 500 DB’s each, is it some option in commvault to run on-demand backup for only one DB out of 500 DB’s. I knew we have SQL plug-in which can be used from the SQL studio but i am looking for some option from the commvault end,
i found below link to run from commvault end but it is not working as expected, not sure what i am missing here.
This command requires you edit a text file with the database(s) that you want to backup. It can be scheduled to run with task scheduler within windows or similar options.
Also if you have specific databases that need one time backup it might be beneficial to create a subclient just for those DBs.
This command requires you edit a text file with the database(s) that you want to backup. It can be scheduled to run with task scheduler within windows or similar options.
Also if you have specific databases that need one time backup it might be beneficial to create a subclient just for those DBs.
This command requires you edit a text file with the database(s) that you want to backup. It can be scheduled to run with task scheduler within windows or similar options.
Also if you have specific databases that need one time backup it might be beneficial to create a subclient just for those DBs.
Thanks Scott for your help here ! I tried to run the qcommand but it is running backup for all the DB’s even though i gave only one DB on the text file. not sure what i am missing. problem in creating new Subclient for one DB is that after backup completed, we cant remove that DB and add to the default sub-client until we delete the sub-client or add another DB to the sub-client.
This command requires you edit a text file with the database(s) that you want to backup. It can be scheduled to run with task scheduler within windows or similar options.
Also if you have specific databases that need one time backup it might be beneficial to create a subclient just for those DBs.
Thanks Scott for your help here ! I tried to run the qcommand but it is running backup for all the DB’s even though i gave only one DB on the text file. not sure what i am missing. problem in creating new Subclient for one DB is that after backup completed, we cant remove that DB and add to the default sub-client until we delete the sub-client or add another DB to the sub-client.
Actually I didn’t mean Command line, for running on demand backup. It’s in the Command Center GUI which is a web interface. You can run on-demand backup for any database from the UI.
But for scheduling you need to make it part of the subclient and create schedule for that.
This command requires you edit a text file with the database(s) that you want to backup. It can be scheduled to run with task scheduler within windows or similar options.
Also if you have specific databases that need one time backup it might be beneficial to create a subclient just for those DBs.
Thanks Scott for your help here ! I tried to run the qcommand but it is running backup for all the DB’s even though i gave only one DB on the text file. not sure what i am missing. problem in creating new Subclient for one DB is that after backup completed, we cant remove that DB and add to the default sub-client until we delete the sub-client or add another DB to the sub-client.
Actually I didn’t mean Command line, for running on demand backup. It’s in the Command Center GUI which is a web interface. You can run on-demand backup for any database from the UI.
But for scheduling you need to make it part of the subclient and create schedule for that.
Thanks,
Sunil-
Hi Sunil,
Thanks for your response. Scott specified that we can use command line to run an on demand backup and can schedule it so when i tried the command line, backup is getting triggered for all the DBS on the Subclient.
command used and on the db.txt, i have specified couple of Db;s
I want to run backup of only one DB in the default sub-client and default sub-client has some 500 DB’s in it, if i need to create on-demand sub-client and put the DB in that Subclient then i cant move the db out of on-demand sub-client until i add another db to it or delete the on-demand sub-client.
I can do this on the command center by manually clicking the DB but i need to schedule and automate this process. Do we have any options.
The ondemand subclient is different. There is no Content tab. Databases are not moved from their existing subclient it will only backup the DBs that are in the text file when running the ondemand backup.
No the ondemand subclient is different. There is no Content tab. Databases are not moved from their existing subclient it will only backup the DBs that are in the text file when running the ondemand backup.
AAH ! sorry scoot, i missed that. I tried few time but no luck. i believe i am missing something here. can you please review the command once! Thanks.
No the ondemand subclient is different. There is no Content tab. Databases are not moved from their existing subclient it will only backup the DBs that are in the text file when running the ondemand backup.
AAH ! sorry scoot, i missed that. I tried few time but no luck. i believe i am missing something here. can you please review the command once! Thanks.
this was fixed and working as expected, i just copied pasted the commands directly which made the issue. i typed the command and it worked fine. Thanks for your inputs and suggestions.
We use 3 different kinds of cookies. You can choose which cookies you want to accept. We need basic cookies to make this site work, therefore these are the minimum you can select. Learn more about our cookies.