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 |
|
asm
Posting Yak Master
140 Posts |
 Posted - 2008-01-19 : 01:46:35
|
| HiIn my database :.mdf file size = 209 mb.ldf file size = 3739 mbPls guide how to control the .ldf file size.for .ldg autogrowth is given only 10% thanks |
|
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
Posted - 2008-01-19 : 02:24:05
|
| take log backup of the database.VinodEven you learn 1%, Learn it with 100% confidence. |
 |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2008-01-19 : 04:58:08
|
| If you don't want to backup and you just want to truncate the inactive part , BACKUP LOG pubs WITH TRUNCATE_ONLYJack Vamvas--------------------Search IT jobs from multiple sources- http://www.ITjobfeed.com |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-01-20 : 20:32:46
|
| In that case, better to set db to simple recovery mode. |
|
|
|
|
|
|
Database Size