Hi Team,
I have two separate SQL Servers. Can I make a definition such that when the backup of one ends, the backup of the other one starts after that?
Solved
Running a sequential backup
- Novice
Best answer by Scott Reynolds
Save as a script the second client machine backup type you like. Place that in the post backup script section for server1 and ocne complete it will kick off the backup.
https://documentation.commvault.com/2023e/expert/save_as_script_overview.html
https://documentation.commvault.com/2023e/expert/pre_processes_and_post_processes_overview.html
You could also leverage commandline functions and add them into a native script that you create.
Otherwise
+13- Vaulter
I don’t think this is achievable by the in-built scheduling. But you can write a workflow to trigger the backups on these two servers one after the other and schedule this workflow.
Curious what is the use case though.
Thanks,
Sunil-
- Vaulter
- Answer
Save as a script the second client machine backup type you like. Place that in the post backup script section for server1 and ocne complete it will kick off the backup.
https://documentation.commvault.com/2023e/expert/save_as_script_overview.html
https://documentation.commvault.com/2023e/expert/pre_processes_and_post_processes_overview.html
You could also leverage commandline functions and add them into a native script that you create.
Otherwise
- Novice
Hi
I guess Pre/Post Script is not supported by Always on SQL Subclient, it is greyed out. this couldn’ t be achievable by post script.
When backup runs at the same time, there is heavy CPU usage on the server. The first backup can sometimes lag, so unfortunately it cannot be clear in the time we put between two backups. The most logical thing is to have a sequential backup, when the first backup is finished, let the second one run.
Is it possible to achieve this with Workflow, how can I do it?
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.