No apology needed. I thought that was close, but it wasn't an attack, but more of a comment that I saw out of disgus or frustration.

I haven't heard back, and...

But doesn't the roll forward include the log records in the full backup? The backup starts, this 2.1B row trans then hits a table that's got some pages in the...

I didn't either. Good trivia item. Probably will stick with me now.

We do not condone brain dumps and will remove any links. We also report the poster and site to MS.

The information you need is on the MS site, and there...

What about a 2B row transaction that occurred during the backup? Wouldn't that end up in rollforward?

I did reply that I thought he was being unprofessional, both in his posts, as well as his approach to the job. I asked him to stop and examine his...

I can see someone getting lost for 20 pages, but the whole thread? That would be something.

It depends on how heavily you're hitting tempdb, and how much IO you're using. I've seen plenty of servers that weren't using tempdb heavily, or were heavy read-weighted servers. Moving...

I did reply that his comments were not very professional and that I disagreed with the way he was approaching the job.

Not that it matters, but others need not lower...

The difference is that when I did a lot of this, we didn't have try..catch logic.

It may or may not be different with try..catch. Haven't used it enough in breakage...

I've used lots of cursors for small jobs like this, things where I need to run something as a one-off. I've never had issues, but they've mostly been small...

That thing that seems strange is that you are checking the property of if this is a user table. Is the type commented out? Hard to tell from the formatting....

If you're not moving to faster drives, I'm not sure you get better performance from tempdb, it's more likely that the overall I/O on the server instance is better.

What you...

I tend to agree with Jeff, but I don't see a huge problem with the cursor. The thing I don't like is putting this in a job step.

Instead I'd create...

Yes, it has SSRS.

The thing you want to be careful of with going 2008 is that some things you might work on, or try, will not work on 2005. Most...