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 - 2002-06-20 : 08:37:53
|
| Nap Cacanindin writes "Hi Guys, I hope you can help me find solution for my growing SQL Transaction Log. It's been growing up to 5G and keep on growing. How can I clear or delete this log so that i can limit it to at least 2G only. Right now, i cannot limit it to lower size. Please help..Thanks.Nap" |
|
|
izaltsman
A custom title
1139 Posts |
Posted - 2002-06-20 : 08:55:18
|
| What recovery mode did you set for your database? If it is set to Full or Bulk-Logged, you must perform log backups periodically. After you back up the log, the inactive portion will be truncated, and you will be able to shrink the file, using DBCC SHRINKFILE command. |
 |
|
|
|
|
|
SQL 2000 Log File Size