Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2000-10-26 : 17:24:46
|
Eric writes "Can you explain the sql transaction log for me? What I don't understand is why I would want it to grow. My programmers are working on an application that built a 1.7gb log file in a few days. My thinking is why do I need this log file. I want to limit it to a smaller file, but do not know the consequences.
Scenerio: Online testing application for testing of 100 to 300 students simutaneously with 100 to 500 questions. (Multiple choice, fill in blank, t/f) Questions randomized with auto. Very complex app with massive I/O.
Server: Dell Poweredge 2400 Dual 933 with 1gb ram. 9gb 10000rpm system drive, 18 gb 10000rpm data drive for databases.
OS: Win2k Advanced server / SQL 2000 final release
Please help!" |
|
|
|
|
|
Log files