AutoShrink

Hi!
I have a question about the log file of my db, it
increases day by day of a lot of MB!!
To reduce its size I make the back up of transaction log
and then the Shink db tasks by Enterprise Manager.
I wonder if I check to true the option Auto Shrink on the
tab Option of the my db's properties, I get the same
result.
the Help sais that if this check is valued true, the
server periodically make the shrink...but "periodically"
means WHAT? and the resize would be the same I obtain with
the statements?
Thanks!If your log is legitimately growing, don't use auto-shrink, it will just
hurt your performance in your most active times of the day. If you do not
require point in time recovery, use simple mode.
HTH
Ray Higdon MCSE, MCDBA, CCNA
--
"milena" <anonymous@.discussions.microsoft.com> wrote in message
news:955b01c3eb00$94202d90$a301280a@.phx.gbl...

quote:

---

> Hi!
> I have a question about the log file of my db, it
> increases day by day of a lot of MB!!
> To reduce its size I make the back up of transaction log
> and then the Shink db tasks by Enterprise Manager.
> I wonder if I check to true the option Auto Shrink on the
> tab Option of the my db's properties, I get the same
> result.
> the Help sais that if this check is valued true, the
> server periodically make the shrink...but "periodically"
> means WHAT? and the resize would be the same I obtain with
> the statements?
> Thanks!
>

---

|||The tran log will be truncated "periodically" when the database is in
simple recovery mode... The process that does this is the checkpoint
process. You may adjust the frequency of checkpoints ( and the log
truncation ) using sp_configure "recovery interval". The default setting
causes this to occur every minute.
"milena" <anonymous@.discussions.microsoft.com> wrote in message
news:955b01c3eb00$94202d90$a301280a@.phx.gbl...

quote:

---

> Hi!
> I have a question about the log file of my db, it
> increases day by day of a lot of MB!!
> To reduce its size I make the back up of transaction log
> and then the Shink db tasks by Enterprise Manager.
> I wonder if I check to true the option Auto Shrink on the
> tab Option of the my db's properties, I get the same
> result.
> the Help sais that if this check is valued true, the
> server periodically make the shrink...but "periodically"
> means WHAT? and the resize would be the same I obtain with
> the statements?
> Thanks!
>

---

|||Hi.
SQL Server execute Shrink Method for remove unused pages. All depend of how
You have the RECOVERY MODEL of the SQL Server, dependding on this its grow y
our log file.
FULL: Save all information about transactions
SIMPLE: Only Save the neeseraly important
SQL Server only can Shrink the Space Free, this depends on the Checkpoints t
he SQL Server, and this goes associated to BACKUP Process.
The AutoShrink is not very good. It is better than executing for Transact-S
QL with a Work, and thus your you can determine when this task is executed.
The AutoShrink is not very good. It is better than executing for Transact-SQ
L with a Job, and thus your you can determine when this task is executed.
Look -> Books Online -> Index [Shrinking a Database ]
Look -> Books Online -> Index [Selecting a Recovery Model]
Hermilson Tinoco