Does this help:

http://sql-server-performance.com/Community/forums/p/3192/17035.aspx

This was a hard one to research on.

no, but why would you want to do this?

Lynn,

Sorry you got sucked in there.

Feel like I'm babysitting today.

This is one of the top priorities on my dev list. I'm hoping it will get done by next week.

Is that the query or is it mailto:jeff.moden@supersqlguy.com?

Two weeks is US standard. I actually have a contract specifying more.

Did your previous employer set their own policy? Is that legal in NZ?

I removed language that was offensive from the posts. It was not intended to show Crazyroc in a bad light, but to remove offensive language. Adding it back doesn't prove...

You don't need a set, just restore it.

I don't think so. I think the diff backup is when it ends.

You could just offset your logs slightly. It will also tell you if you're out of sequence with...

I'd agree with Gail here. You might cause issues with the TOP 1 if you have multiple rows updated

I'd argue his real problem appears to be a lack of communication. He doesn't appear to understand how to frame a problem or question.

I'd also check and be sure the server is running.

I have edited a number of posts here as there's no place for calling names in the forums. If you don't receive the answer you like, please ask, or ignore...

Moving to 2005

That message is usually when you have striped the backup to multiple files.

Do you have the backup command, and the restore command?