Wow, the pointer info is good information to have.

I do know that one of the options is to use the Agent version of the backup. The other is to use...

I'm...

SQL Server will NOT allow you to restore files out of order. See my post about backup chains. You can read up about it in BOL too.

There's really nothing to...

Ouch!

Might I recommend only using Differential on a daily basis (not an hourly) and backing up the Transaction Log on an hourly basis instead?

I've never seen Differentials as an "hourly"...

Sorry -- my bad -- not...

Or does SQL mindlessly try to do a Log file backup right during a Full backup? That would really mess things up, wouldn't it? What if it did a log...

You could always set the status notification to run every 5 or 10 or X minutes and check to see if the job status / last run date & time...

As I said, it sounds like the package hasn't "completed" when you're seeing the failure.

Can you attach a screen shot of the package when it's failed? I might be...

cRuchika,

FYI: I can't see whatever you posted in the scroll box.

Regarding a failed package but everything looks green or yellow? I've seen it before when a package has a task...

patwarimk (2/22/2010)

---

Hello, This is Praveen, Iam a tester and please can you give me some information while migrating Database from SQL Server 2000 to SQL Server 2008 what we need...

Thank you for this. I'm definitely voting on the connect item and will take a look at all suggestions as I really don't want to create a Gantt Chart Manually.

I did read the whole comment. It's just that the first paragraph of any email or post sets the tone for the rest of it. Which means your final comment...

Tom,

I understand...

I'm sure there are a lot of differences between your servers and mine, but this fix was a permanant fix for us. I've had it in affect for almost 2...

Precaution and dropping / recreating your maintenance plan are your only two solutions for now.