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 |
|
mapperkids
Yak Posting Veteran
50 Posts |
 Posted - 2007-05-02 : 12:07:29
|
| Hi,One of our db size is 700MB and I don't why the transaction log file is three times bigger which is 2200MB, Does the log file and it grow everyday by 5 percent (it is what setting now).I think the actual data is in the MDF file not the LDF file, can I delete the LOG file and start again. or how to make it smaller? or any way to don't let it keep growing growing everyday?Thanks! |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-05-02 : 14:10:50
|
| If the db is not in simple recovery model, you have to backup log periodically to keep log file in reasonable size. |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2007-05-02 : 16:39:03
|
| See also: http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=55210&SearchTerms=Why%20is%20my%20LDF%20Log%20File%20so%20big |
|
|
|
|
|
|
File Size question?