While monitoring the logical log files I noticed that they were often smalle
r
in the morning. I've been trying to find what is doing the shrink.
I see nothing in the maintenance plan about trunking the log file and I have
found nothing else.
The only clue I have is that, on a slow day, the date stamp on the file is
just a couple minutes after the machine reboot.
I want to avoid the fragmentation that happens when the file grows.
Can anyone help me explain this?Autoshrink?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"JayKon" <JayKon@.discussions.microsoft.com> wrote in message
news:DF4BED2D-93CD-4293-A2C8-819718C3A1EB@.microsoft.com...
> While monitoring the logical log files I noticed that they were often smal
ler
> in the morning. I've been trying to find what is doing the shrink.
> I see nothing in the maintenance plan about trunking the log file and I ha
ve
> found nothing else.
> The only clue I have is that, on a slow day, the date stamp on the file is
> just a couple minutes after the machine reboot.
> I want to avoid the fragmentation that happens when the file grows.
> Can anyone help me explain this?
No comments:
Post a Comment