[dba-SQLServer] Shrinking log file

Eric Barro ebarro at verizon.net
Fri Feb 10 13:15:12 CST 2006


Mark,

You can do that using EM. Go into the properties and look for the log file
and specify a log file size. You will need to schedule a job that will
shrink the log file periodically because once you set a limit it will
complain when it reaches that limit and all your SQL operations will come to
a standstill.

Basically the drill is...

1. Set your tlog filesize to something you are comfortable with.
2. Create a backup job that backs up the tlog.
3. Create a shrink job that shrinks the tlog right after it is backed up.

This will ensure that your tlog is optimized.

Eric 

-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of
Mark.Whittinghill at protective.com
Sent: Friday, February 10, 2006 7:25 AM
To: dba-sqlserver at databaseadvisors.com
Subject: [dba-SQLServer] Shrinking log file

Is there any way to decrease the size allocated for a log file?  I know how
to shrink it, but I can't decrease the allocated size.

Thanks,

Mark Whittinghill
Sr. Programmer Analyst
Protective - Asset Protection Division
636.536.5720
Mark.Whittinghill at protective.com


-----------------------------------------
Confidentiality Notice: This e-mail communication and any attachments may
contain confidential and privileged information for the use of the
designated recipients named above. If you are not the intended recipient,
you are hereby notified that you have received this communication in error
and that any review, disclosure, dissemination, distribution or copying of
it or its contents is prohibited. If you have received this communication in
error, please notify me immediately by replying to this message and deleting
it from your computer. Thank you.
_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com




More information about the dba-SQLServer mailing list