Sorry for the incomplete syntax tsc1, the caffiene has just kicked in

Also I have tried shrinking logs in EM via taskpad, but it never works. ...

Hi,

You can either do

dbcc shrinkfile (dbid, n) --where dbid is the fileid in sysfiles and n is the target MB size

Or

backup log yourdbname with truncate_only

Ritch

Edited by - Ritch on 06/18/2003...

Hi,

I don't know whether this will help but I had a similar problem with a job I migrated to another server. I had to change the originating_server field in...

Thanks, no worries on that one my backs got more coverage than the gulf war had

I don't reckon it's a bug, it happens on the SQL 7 servers as well. It's almost definately a problem with out code.

I live in hope of the dev...

Thanks for the reply. I totally agree with what you said but theres a political issue with the customer they are supposed to provide their own 1st line support....