>>Did you perform a backup of the log file prior to trying to shrink the db?
>
>No, is this a factor in the DBCC command when being executed?
Yes, when you do a backup of the log then the space gets "freed" and then you should be able to shrink it
[update]well, i read Sergey's post and he has a point, it depends on the recovery setting, I assumed full
"The five senses obstruct or deform the apprehension of reality."
Jorge L. Borges?
"Premature optimization is the root of all evil in programming."
Donald Knuth, repeating C. A. R. Hoare
"To die for a religion is easier than to live it absolutely"
Jorge L. Borges
