Log file increase very fast

I installed SQL server 2000 on one NT4.0 server and one Win2000 server. The
SQL server on NT4.0 is working fine. It's log file is always less than 5MB.
But on Win2000 I think there are some problems because the log file is
increasing very fast,now it is 25000MB.The two SQL server almost do same
work and configuration are same. Any help will be appreciated.Charms,
Have you checked the database settings on both servers . You may have one
server set to a higher recovery model.
I hope this helps
regards
Greg O MCSD
http://www.ag-software.com/ags_scribe_index.asp. SQL Scribe Documentation
Builder, the quickest way to document your database
http://www.ag-software.com/ags_SSEPE_index.asp. AGS SQL Server Extended
Property Extended properties manager for SQL 2000
http://www.ag-software.com/IconExtractionProgram.asp. Free icon extraction
program
http://www.ag-software.com. Free programming tools
"Charms Zhou" <charmszhou@.hotmail.com> wrote in message
news:uWzADRraDHA.2580@.TK2MSFTNGP09.phx.gbl...
> I installed SQL server 2000 on one NT4.0 server and one Win2000 server.
The
> SQL server on NT4.0 is working fine. It's log file is always less than
5MB.
> But on Win2000 I think there are some problems because the log file is
> increasing very fast,now it is 25000MB.The two SQL server almost do same
> work and configuration are same. Any help will be appreciated.
>|||Also, perhaps you are doing index rebuilds on one machine but not the other?
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as ugroup=microsoft.public.sqlserver
"Greg Obleshchuk" <greg@.ag-software.com> wrote in message
news:unhttPsaDHA.2632@.TK2MSFTNGP09.phx.gbl...
> Charms,
> Have you checked the database settings on both servers . You may have one
> server set to a higher recovery model.
>
> --
> I hope this helps
> regards
> Greg O MCSD
> http://www.ag-software.com/ags_scribe_index.asp. SQL Scribe Documentation
> Builder, the quickest way to document your database
> http://www.ag-software.com/ags_SSEPE_index.asp. AGS SQL Server Extended
> Property Extended properties manager for SQL 2000
> http://www.ag-software.com/IconExtractionProgram.asp. Free icon extraction
> program
> http://www.ag-software.com. Free programming tools
>
> "Charms Zhou" <charmszhou@.hotmail.com> wrote in message
> news:uWzADRraDHA.2580@.TK2MSFTNGP09.phx.gbl...
> > I installed SQL server 2000 on one NT4.0 server and one Win2000 server.
> The
> > SQL server on NT4.0 is working fine. It's log file is always less than
> 5MB.
> > But on Win2000 I think there are some problems because the log file is
> > increasing very fast,now it is 25000MB.The two SQL server almost do same
> > work and configuration are same. Any help will be appreciated.
> >
> >
>