** Private ** wrote:
> One of my databases has developed a 32Gb log file (ProductData_Log.LDF) and
> I can't seem to shrink it.
Switch your database to simple logging, run a checkpoint and the
dbcc_shrinkfile. When it has completed, switch your database back to full
logging and then create a mai
hmmm... i think i have simply deleted one, and it simply created one
itself, but dont take that
as the answer... PURELY a last option case that i KINDA remember from years ago.
honestly, this post is worthless so just disregard it anyway :)
hope you figure it out.
tw
On Jan 29, 2008 10:00 AM, Ja
One of my databases has developed a 32Gb log file (ProductData_Log.LDF) and
I can't seem to shrink it.
I have tried...
DBCC SHRINKFILE(ProductData_Log, 2)
With no luck (although it did report successful completion).
I have tried...
BACKUP LOG ProductData WITH TRUNCATE_ONLY
And...
BACKUP LOG
