December 19, 2003 at 12:36 pm
I have a database for which we have scheduled One hour backup. For some reasons i dont know why my Log file XYZ_log.LDF goes go upto size 5 GB . My total Size of drive is 8GB ..so bcos of this the database becomes Single user . Right now I am using dettached and attached to solve this .But some one has to be there to frequently monitor the size.
My Queries :
1. what is the reason for LOg file size growth .
2. Is this because of Uncommitted transactions.( we have some inhouse applications which opens connection but did not set to nothing )
3. Is this because of One hour back daily.
thanks
Venu
Venu
December 19, 2003 at 12:38 pm
Are you using transaction log backups or are sticking strictly to full/differential?
K. Brian Kelley, GSEC
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
K. Brian Kelley
@kbriankelley
December 19, 2003 at 12:48 pm
I have a database maintenace plan which will back up both database and transaction log too .. File extensions are
.BAK and .TRN
Venu
Venu
December 19, 2003 at 2:12 pm
Are you rebuilding indexes as part of your maintenance plan? That will cause the log to grow to about the size of the data.
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply