Thanks for that Jan, I'll give that a go

I can now see where in one of my attempts in doing it I went wrong. I didn't pass a parameter to...

I have now got a work around by putting the results of the sp into a temp table then, as the data is always only one row, assigning the variable...

Thanks Silverfox for the info (I had already found Tibor's article on this which is what led me to the backup shrinkfile)

I have now cured the symptoms. I checked the...

Update:-

After a log backup and log shrink things are a bit neater now with regard to dbcc loginfo figures :-

[font="Courier New"]FileId FileSize ...

OK - so really numpty time - the results are attached. What does this tell me?

Hi Silverfox,

I've updated the stats and this reduces the value to be nearer zero but still a lrage negative value.

dbcc sqlperf(logspace) gives :

DB ...

Double posted on this one - sorry please do not reply to this thread

Many thanks for your prompt reply

Stuart

Erik,

You sir, are a star!!

Many thanks

Stuart

I'm having a similar problem but the error is "operating system error 112 error not found".

Again - I've got more than enough disk space 114 Gb on NTFS 136 Gb drive....

What if

select SERVERPROPERTY('LicenseType')

returns "Disabled" - what does that mean?

In answer to all your points / questions - in no particular order

Data was moved by scripting the table including indexes running on Dev server then DTS the data between...

All,

Thanks for your comments. I think the biggest issue is what was going on in the back ground on both the servers. There quite large differences in the back ground...

Now sorted this one - it was a problem with indexes

Stuart

It doesn't matter where I script it from (QA or EM on any PC) the difference seems to be on the server options - but both servers are set up...