January 25, 2009 at 8:42 am
Hi,
I have scheduled an hourly transaction log backup and some times I see something strange.
At certain times of the day the transaction log files created are too large (25 GB) for a specific database.
Why is this TRN getting so big, and what should I do about resolving this?
Thank you
John
January 25, 2009 at 9:44 am
If the transaction log gets really big, it's because of activity. Changes in the database. No bugs or other things cause this to grow.
Perhaps you're rebuilding indexes? That will grow the log.
January 25, 2009 at 4:44 pm
Does Index Rebuilt prevent users from login?
The database had heavy loaded tables that time.
Thank you
John
January 25, 2009 at 5:31 pm
It doesn't affect logging in. It's possible that you can't access a table while the index is being rebuilt if its' the clustered index, but it should appear as a block in your system.
If you are loading tables, that will also cause the log to grow.
January 26, 2009 at 1:43 am
j.grimanis (1/25/2009)
Does Index Rebuilt prevent users from login?The database had heavy loaded tables that time.
Thank you
John
It will prevent table..but prevent to use indexes..
January 26, 2009 at 2:15 am
Hi,
Is it possible when the LOG´s partition on disk is full to prevent users to log in?
Thank you
John
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply