Transaction log - full ?
SQL SERVER 6.5
Doing a large update on a table is causing syslogs full error.
My log is 400MB.
When I do a DBCC CHECKTABLE(SYSLOGS) I see 388mb still
free on the log. Dumping the transaction log with no_log clears the log
to 400mb again.
Increasing the log to 500mb allows some updates to complete
but large ones fail again with syslogs full though there is 388mb free when
I do DBCC CHECKTABLE(SYSLOGS)
Anybody come across this before ? Is my log corrupt ?
Came across the following on the web to rebuild the log but it doesn't work
dbcc rebuildlog (@dbname, 1, 0)
-- Android Development Center
-- Cloud Development Project Center
-- HTML5 Development Center
-- Windows Mobile Development Center