Viewing 15 posts - 8,146 through 8,160 (of 9,720 total)
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...
March 16, 2010 at 12:56 pm
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"...
March 16, 2010 at 12:50 pm
I'm not sure if your 1:05 tran log backup is junk. Perhaps it would be useful to restore to point-in-time before the full backup completed.
Sorry -- my bad -- not...
March 16, 2010 at 12:41 pm
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...
March 16, 2010 at 12:33 pm
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...
March 16, 2010 at 12:08 pm
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...
March 10, 2010 at 5:10 am
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...
March 9, 2010 at 10:12 am
patwarimk (2/22/2010)
February 24, 2010 at 5:56 am
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.
February 5, 2010 at 6:37 am
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...
January 26, 2010 at 10:32 am
Tom.Thomson (1/25/2010)
This response is directly to the editorial - I haven't read any of the other comments yet..... If you think that, you are crazy!...
Tom,
I understand...
January 26, 2010 at 6:50 am
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...
January 21, 2010 at 12:10 pm
Precaution and dropping / recreating your maintenance plan are your only two solutions for now.
January 21, 2010 at 5:52 am
Unless it's included in SP2 or the SP1 Hot Fix, no. We don't have it applied to our clustered servers.
Of course, the initial solution I posted worked for us, so...
January 21, 2010 at 5:50 am
mirde (1/15/2010)
January 18, 2010 at 6:07 am
Viewing 15 posts - 8,146 through 8,160 (of 9,720 total)