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 |
|
TAS
Yak Posting Veteran
65 Posts |
 Posted - 2004-06-11 : 15:43:48
|
| The transaction log grows very fast. Anybody knows how to clear it? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-06-11 : 15:55:27
|
| BACKUP LOG.What is your database recovery model set to? Right click on your db in EM, go to properties, then to Options tab. Does it say FULL? If so, you need to perform transaction log backups. If you don't require point in time recovery, then change it to SIMPLE.Tara |
 |
|
|
|
|
|
Clear Transaction Log