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 |
|
00kevin
Yak Posting Veteran
78 Posts |
 Posted - 2010-06-18 : 09:31:49
|
| Hi,I have a table that is being updated every second (sometimes twice per second).What should I do to this table to ensure that the log files don't get to large? |
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2010-06-18 : 09:33:49
|
| 2 options:- Backup the tlog frequently- Set the database to simple recovery model- LumbagoMy blog (yes, I have a blog now! just not that much content yet) -> www.thefirstsql.com |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2010-06-18 : 10:36:17
|
| Inserting multiple rows at once, rather than one-by-one, may reduce log size. |
|
|
|
|
|
|
table updated every second