Ah, ChrisM@Work, I think I get what you were saying now.

and LEN(LTRIM(RTRIM(CURRENT_POINT))) > 0

Seems to have fixed it.

Thanks all!

Thanks for the replies so far.

Using that doesn't exclude the rows with blanks in, if that's what you mean?

I'm sorry, I'm...

Oh no, you don't need to apologise to me; I'm nobody special! Sorry if it seemed that way. I just wondered if it might be illustrative of your job-hunting technique...

Well, it's quite hard to advise you based on what you've said, but I notice that you've posted the same question numerous times across the various boards. If you're applying...

Where are you looking, and what sort of feedback are you getting when you apply?

Congratulations, first off!

Your reaction to leaving your job of 10 years is understandable. Everybody doubts themselves when they start a new job, everybody. You spend the first 6 months-1 year,...

Made me laugh!

How long does it take to fetch the offsite backup, and how long will...

GilaMonster (2/12/2013)

---

Beatrix Kiddo (2/12/2013)

---

I know how to produce a backup file with the date in the name, but where does that leave me when I need it to be overwritten...

The database or the transaction log, is this? The space issues we have mean...

So I've done that and now the log_backup.bak file is actually larger than it was, and is now larger than the database.bak file. Have I done something wrong here?

Now that you say that (about points 1 & 3) it is actually obvious; sorry about that.

We do have overnight backups going to tapes in an external data vault.

Thanks...

Thank you. I'll do that once I've done some more reading. I do wish everybody here hadn't quit, this is all a bit much!

Can I go ahead with steps 1-5...

Coincidentally I was just reading that article and was coming back to edit my post, but too late!

Is everything else ok though, apart from the need to set the log...