February 28, 2022 at 9:46 pm
Hello,
One of the full back up job failed and it was triggered again. The DB's size is big so it takes couple of hrs to complete.
My questions is ....if the running job does not finish before the scheduled time when it starts...will it fail or stop current run?
Is there a way to skip just todays schedule for running job and not fail it? if yes, then that way, I can run it manually after it completes the current run...
February 28, 2022 at 9:50 pm
If a job is currently running, an attempt to start the job will fail (it will essentially be ignored).
Say JobA starts at 1PM and is schedule to start very hour. If JobA is still running at 2PM, a new job is NOT started but the existing job is not cancelled either.
SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".
February 28, 2022 at 9:51 pm
Btw:
Are you using compressed backups?
Do you use page compression on the data in large tables?
SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".
March 1, 2022 at 5:34 pm
Hello,
One of the full back up job failed and it was triggered again. The DB's size is big so it takes couple of hrs to complete. My questions is ....if the running job does not finish before the scheduled time when it starts...will it fail or stop current run?
Is there a way to skip just todays schedule for running job and not fail it? if yes, then that way, I can run it manually after it completes the current run...
What kind of backups are you performing, how big is the database, where are the backups being written to, and how long does this take?
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
March 1, 2022 at 5:40 pm
It might be a good idea to take differential backups until you resolve the problem with full backups.
You could even add it as a job step, to run only if the full backup fails.
March 2, 2022 at 7:55 am
This was removed by the editor as SPAM
March 2, 2022 at 2:00 pm
This was removed by the editor as SPAM
April 22, 2022 at 3:01 am
This reply has been reported for inappropriate content.
8X's reviews are often detailed and unbiased. You'll learn about the latest games released by reading these reviews, which is a great way to get in-depth information about new games. In addition to the reviews, the site has forums and video shows where you can ask questions about the games. As a result, you'll get a fair idea of whether or not you'll like the game before you purchase it. Besides, these sites have a wealth of content, including a good deal of gaming news.
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply