I might be missing something obvious but is there not a way to schedule a one-time/ad-hoc backup of a single database from within either the web-based Command Center or the desktop CommCell Console?
- I know where you can backup a single database, on-demand, from the web-based Command Center
- and I know where you can schedule a one-time backup of an entire instance/subclient
- but I don’t see where you can combine those two scenarios to create a scheduled backup of a single database.
Best answer by LedoespView original
Is that about right? I’m not seeing any way to do that without splitting the other database into another subclient.
I’ll see if anyone else has any methods, maybe using the Command Line that you can schedule out.
One way I know to run a single SQL database backup is using the SQL Management Studio plugin however you have no option to schedule. This invokes a qcommand, probably the one described here for OnDemand backup https://documentation.commvault.com/commvault/v11_sp20/article?p=18360.htm
Once you have the command with the right syntax and tested you can think about scheduling it ….
Also I found a Powershell module available for SQL, Backup-CVSQLDatabase:
Thanks to you both!
This can be done in the older Java console. You can run ad-hoc backups in CC, however they can’t currently be scheduled. This is done under the “databases” window in CC.
Hey, Mike. CMR 315159 was generated to enable scheduled, ad-hoc backups in the web client (Command Center).
And what about creating a new Schedule Policy, adding a new schedule task in it, with “one time” option selected, then selecting the SQL server in the “Associations” tab ?
It takes 2 minutes, and it is native in commvault.
What do you think ?