goprasad
asked on
Set-up Maximum Log File Size growth in SQL 2005
depends on how big your datafile is . if its a huge datafile and you are doing huge updates or inserts or even reindexing, or sorting then 2GBs will fill up quite quickly. i would suggest you set it to grow by 10% and monitor it for a few weeks. If you are satisfied that xGBs is the max file to keep then set it to that.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Its better to analyze your database growth with 2 TB\unlimited growth option for a week and then set your criteria with this. As others said above, the log growth completely depends upon the transactions happening on the server, so I think this is the correct way. Apart from that the percentage of size growth also matters a lot. Consider it too for configuring your log.