Log File Size (SQL 2000)

Dear All,
How to maintain the transaction log file size ?
When I should use Restrict filegrowth or Unrestricted filegrowth ?
How many MB shoud I setup for the log file size ?
Thanks.
Vensia
Hi
http://www.sql-server-performance.co...e_settings.asp
"Vensia" <vensia2000_nospam@.yahoo.com> wrote in message
news:eUNfuu1FGHA.752@.TK2MSFTNGP12.phx.gbl...
> Dear All,
> How to maintain the transaction log file size ?
> When I should use Restrict filegrowth or Unrestricted filegrowth ?
> How many MB shoud I setup for the log file size ?
> Thanks.
> Vensia
>

Log File Size (SQL 2000)

Dear All,
How to maintain the transaction log file size ?
When I should use Restrict filegrowth or Unrestricted filegrowth ?
How many MB shoud I setup for the log file size ?
Thanks.
VensiaHi
http://www.sql-server-performance.com/database_settings.asp
"Vensia" <vensia2000_nospam@.yahoo.com> wrote in message
news:eUNfuu1FGHA.752@.TK2MSFTNGP12.phx.gbl...
> Dear All,
> How to maintain the transaction log file size ?
> When I should use Restrict filegrowth or Unrestricted filegrowth ?
> How many MB shoud I setup for the log file size ?
> Thanks.
> Vensia
>

Log File Size (SQL 2000)

Dear All,
How to maintain the transaction log file size ?
When I should use Restrict filegrowth or Unrestricted filegrowth ?
How many MB shoud I setup for the log file size ?
Thanks.
VensiaHi
http://www.sql-server-performance.c...se_settings.asp
"Vensia" <vensia2000_nospam@.yahoo.com> wrote in message
news:eUNfuu1FGHA.752@.TK2MSFTNGP12.phx.gbl...
> Dear All,
> How to maintain the transaction log file size ?
> When I should use Restrict filegrowth or Unrestricted filegrowth ?
> How many MB shoud I setup for the log file size ?
> Thanks.
> Vensia
>