October 27, 2009 at 8:37 am
October 27, 2009 at 9:08 am
Sorry, but I don't see anywhere where they say to limit the max size.
Under the section "Prevent the transaction log files from growing unexpectedly" there's
Set the current size to a large value
Set the auto grow to fixed amounts not %
Change recovery model
Design transactions to be small
Back the log up frequently
Ensure that transactions can't be left uncommitted
Use index defrag rather than reindex
Am I not seeing a paragraph somewhere?
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
October 27, 2009 at 9:17 am
to Set the current size to a large value is a limit.
to Set the auto grow to fixed amounts not % is a limit
October 27, 2009 at 9:29 am
fred2002 (10/27/2009)
to Set the current size to a large value is a limit.
To set the current size to a large size is to just set the current file size. Nothing about the maximum limit on the file size.
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
Viewing 4 posts - 16 through 18 (of 18 total)
You must be logged in to reply to this topic. Login to reply