Wednesday, March 28, 2012

log full message

I have sql server database logs set to expand with no
limit. So why do I get a log full message in the server
log. Thanks, Steve B.Perhaps the log file grew and grew until it filled up the disk.
You will probably want to truncate the log and then shrink it in order =to reclaim the disk space.
-- Keith, SQL Server MVP
"Steve B" <Steve.Baiotto@.ercgroup.com> wrote in message =news:02c301c34a4d$64ae7d40$a501280a@.phx.gbl...
> I have sql server database logs set to expand with no > limit. So why do I get a log full message in the server > log. Thanks, Steve B. >sql

No comments:

Post a Comment