Is there any way to clear out the LDF file or reduce in size?
thank you in advance fro any help,
Michael Kintner
thank you in advance fro any help,
Michael Kintner
-
-
Re: Log File (LDF) ???? (HELP)
Hi
DBCC SHRINKFILE. For more details please see BOL
"Michael Kintner" <nospam@nospam. comwrote in message
news:13dvsktmk6 afhb3@corp.supe rnews.com...Is there any way to clear out the LDF file or reduce in size?
>
thank you in advance fro any help,
Michael Kintner
>
-
Re: Log File (LDF) ???? (HELP)
On Thu, 6 Sep 2007 08:29:16 -0400, "Michael Kintner"
<nospam@nospam. comwrote:
First, what recovery model (Simple, Full, Bulk-Logged) is the database>Is there any way to clear out the LDF file or reduce in size?
>
>thank you in advance fro any help,
>Michael Kintner
using? If Simple, it will clear out by itself. For the others it
will only be cleared with the log is backed up. If no log backups are
running then it simply grows, and grows, and grows....
As for reducing the size, DBCC SHRINKFILE will do the job. However
shrinking the log file should be a VERY rare event. Shrinking the
file, only to have it grow again, is bad for performance. Allocating
more space is a significant delay for the transaction that causes it,
and physical file fragmentation is a common side effect. To over
simplify things a bit, set the log size large enough and backup the
log regularly to keep it from getting full.
Roy Harvey
Beacon Falls, CT
Comment
Comment