April 10, 2008 at 2:36 pm
1. I have the following question on the space allocated for DB's:
From the task pad in enterprise manager(SQL2000), I see the following for one of our db:
Space allocated:
Data:
DBname: 35406.69MB(Used: 33650.19MB; Free: 1756.5MB)
Transaction log space: 11387.74MB(Used: 94.34MB; Free: 11293.4MB)
2. One of our very important db, datafile size is: 16.1GB and logfile size: 31.2GB, I am taking log backup's every 4 hours, is the log size increase due to the less frequent log backup's?? How can I control this log size increase? Shall I shrink the log?
I greatly appreciate all your help. Thanks!!
April 10, 2008 at 7:41 pm
is the log size increase due to the less frequent log backup's?? --> More frequent log backup helps to reduce the log size.
Do you have bulk insert activities, or big chunk of data change (insert/delete/update), or reindex? They are the common causes.
Check what process causes the large log and whether it is reasonable. If it is an acceptable regular activity, no need to shrink log. If just a one time process, should shrink the log back to the normal size.
April 11, 2008 at 8:43 am
More frequent log backups do not reduce the size of the log but does reduce the amount of data contained within the log. In order to keep the log reasonably close to the size you'd want, schedule the logs backups more frequently, say every 30 minutes. The frequency should depend on your business - high data volume, more frequent. There isn't a one-size fits all approach. The good news is that you are taking log backups. As far as shrinking the log file, if you have the available space, I wouldn't, at least not with any regularity. If the log needs to "autogrow" after you shrink, you'll have a performance hit.
-- You can't be late until you show up.
April 11, 2008 at 9:07 am
How about this one, I want to know if Free: 1756.5MB is it okay for the database??
1. I have the following question on the space allocated for DB's:
From the task pad in enterprise manager(SQL2000), I see the following for one of our db:
Space allocated:
Data:
DBname: 35406.69MB(Used: 33650.19MB; Free: 1756.5MB)
Transaction log space: 11387.74MB(Used: 94.34MB; Free: 11293.4MB)
Thanks!!
April 11, 2008 at 9:13 am
What are the sizes of the log backups?
April 11, 2008 at 11:50 am
correction:
--> More frequent log backup helps to reduce the log size.
should be “More frequent log backup helps to free log space to be reused. It will not shrink the log file automatically.
April 11, 2008 at 1:35 pm
Steve Jones - Editor (4/11/2008)
What are the sizes of the log backups?
size of the Tran log backup's is 220MB(average).
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply