10-20-2015 08:48 PM
Hi,
We are currently running a backup for a server and the total size to be backed up is 1TB. some case we need to hold the backup for a while eg after completion of 222gb. Once we right click the running job and select hold option the status goes to "active running hold pending". It is not hold up properly can you suggest me how to get this type of huge data backup to hold. PFB the screen shot.
Thanks in Advance,
Chandra Sudeesh
Solved! Go to Solution.
10-20-2015 11:06 PM
10-20-2015 09:49 PM
10-20-2015 10:04 PM
thank you for the response.
we are trying to hold. our question is why the status goes to running hold pending. PFA.we cant retrive the hold back and make the backup run again.
Can you assist me in reruning the backup again(to remove the hold and change to normal schedule)
10-20-2015 10:13 PM
10-20-2015 10:22 PM
Thank you.
If i give release the hold now and try cancelling the job whether it will help me in cancelling the running job. once we tried cancelling the running job but it went to hung state. so what will be your suggestion on this.
10-20-2015 10:23 PM
10-20-2015 10:24 PM
sorry i forgot to mention this. after holding the job (status running:hold pending) we have restarted the server for maintance purpose. if the backup was in running it is must have failed and status should go to hold right. but that never happened.
10-20-2015 10:30 PM
10-20-2015 11:02 PM
Thank you for the solution. it worked.
But i want to clarify a small thing for future. if status is active running hold pending: Running backup will continue to run and on completion hold will get implemented. We are running sql backup, on initial state, when we triggered the backup we could get the backup completed % through sql log(using queries). but once the status changed to active running hold pending, sql log showed that there were no backup running. why it is so?
10-20-2015 11:06 PM