HI

1 & 2. Leave the file growth in %
3. Recovery Model : FULL
4. i) Memory: Dynamic
ii) Use all available procs
iii) Authentication: Mixed mode(if the n/w has
multiple OS Novell,unix etc)
Audit mode: ALL(if u want the failure and
success to b maintained)
iv)& v) leave these settings untouched.

Regards
Mandeep

--- Bill.[Email Address Removed] wrote:
> We are running SQL Server 2000. I would like input
> on the recommended
> settings for the following:
>
> Database settings:
> 1) Data Files - When you automatically grow the
> file, should
> you use a % or megabytes?
> 2) Transaction Log Files - When you automatically
> grow the
> file, should you use a % or megabytes?
> 3) Recovery Model - Since this is a production
> database and we
> will performing transaction log backups, I am
> assuming we should use the
> Full Model.
> 4) Options - Settings - Here is what is currently
> set (see below or
> attachment)
>
>
>
> Server Settings
> 1)
>
>
>
>
>
>
> Memory - Currently configured to "dynamically
> configure SQL Server
> memory"
> 2) Processor - Currently configured to "use of
> available processors"
> 3) Security -
>
>
>
>
>
>
>
> Authentication is set to "SQL Server and Windows"
> Audit Level is set to "None"
> 4)
>
>
>
>
>
>
>
>
> Database Settings - Default index fill factor to
> use when rebuilding
> indexes is unchecked
>
>
>
>
>
>
>
>
> New database default location boxes are empty
>
>
> Thanks!
> -Bill
>
>
>
>
>
>


__________________________________
Do you Yahoo!?
Free Pop-Up Blocker - Get it now
http://companion.yahoo.com/
MS Sql Server LazyDBA home page