February 2, 2009 at 3:45 am
Hi All,
Does shrinking a Transaction log file will cause any issues?
February 2, 2009 at 4:01 am
It won’t cause any problems, but the question is why do you want to shrink it? If you did something new such as changed the time interval between log backups or if you did a one time maintenance task that caused the log to grow, then you should shrink the log. However if the log got to it’s current size because of the regular use of the database, and nothing was modified, then after you’ll shrink the log, it will get to the point that it will need more space and it will expend again.
Adi
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
February 6, 2009 at 9:52 pm
The diskspace where the log file is present getting low sometimes.I'm getting alerts such as the drive has low space where the log file cannot grow upto the space specified.
The drive only has datafiles and log files.So i thought of shrinking the log files.The log backup occurs twice a day.Interval of 8 hrs.
February 7, 2009 at 2:12 am
Back the log up more often. Maybe hourly. The more often you back it up, the less likely it is to grow large.
You can shrink it, but unless you change something to prevent it from growing large, it will just grow back to the same size again.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 7, 2009 at 3:08 am
Are you reindexing ? that will cause the log to grow big
February 7, 2009 at 5:24 am
Yes rebuilding indexes happens every week..
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply