Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
gunther123
Starting Member
1 Post |
 Posted - 2009-03-24 : 13:22:34
|
| I have used the maintenance plan wizard to setup a differential backup along with a scheduled job to run the plan. Everything works great. Then I used the wizard to setup a transaction log backup. In order to backup the transaction log after the differential backup runs, I modified the differential backup job to include the additional step of running the transaction log backup plan. I have modified the "On success action" value of the first step (differential backup plan) to "Go to the next step" (transaction log backup plan) but it seems that the second step (transaction log backup plan) is not being executed. The differential backup files are showing up but there is no transaction log backup file. The job history shows both steps being executed and I get "The step succeeded" for both steps.I know that the transaction log backup plan works because I can run it individually and it produces the expected transaction log backup file. I am running the differential every hour and the transaction log backup at 15, 30 and 45 minutes after the hour. I did not schedule the transaction log backup for every 15 minutes because I did not want it to interfere with my differential on the hour. Therefore, I was hoping that by adding the second step to the differential backup, I would still achieve a transaction log backup at every quarter hour.I suppose that with my current backup time table, losing the transaction log immediately after the differential backup is not that big of a deal but I'm more concerned over why the step does not seem to be producing results. I'm fairly new to setting up maintenance plans and jobs and I'm thinking that I must have missed something while setting up the second step.Any ideas? |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2009-03-28 : 04:40:01
|
| have you tried a trace - just to make sure the right code is being used - at the appropriate time?Jack Vamvas--------------------http://www.ITjobfeed.com |
 |
|
|
|
|
|
Job with two steps; only first step working