Cool - Thanks guys - This is why this site is rated so highly.

You have given me a few things to ponder !!!!

I'll try what you...

Thanks for all your help.

The normal log bak ups takes around 3 seconds - 15k in size.
The one at 05:30 takes 2.5 minutes and is 1.5GB in...

Thanks for the reply – the issue is the Server is hosted externally and they are trying to say it’s due to the size of our tables. But I’ve checked...

Thanks for your help.

Problem 2

SELECT PARSENAME(REPLACE(Somestring, '||', '.'), 4) + '-' + PARSENAME( REPLACE(Somestring, '||', '.'), 3)

Separate SQL will do.

Thanks.

Thanks guys, i'll give it a go tomorrow.