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 |
|
matt_calhoon
Posting Yak Master
235 Posts |
 Posted - 2004-02-06 : 20:37:24
|
| Hi there,I want to reduce the size of the log file (.ldf) for my databases. The are currently around 300 megs. My databases are set up as follows:Automatically grow file (by percent) Maximum file size=unrestricted for both data and log.I tried setting the options to "Truncate log on checkpoint" and then backed up the db but it did not reduce size. I also tried; backup log <db> with no_log.What can I do to reduce these logs files? |
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2004-02-07 : 03:47:06
|
| What recovery model is your database set to ?If you set it to simple, and turn on autoshrink you should notice a change.Damian |
 |
|
|
matt_calhoon
Posting Yak Master
235 Posts |
Posted - 2004-02-08 : 18:41:53
|
| The db is SQL 7.0 - in options there is an autoshrink checkbox - will this cause any adverse effects if I enable? |
|
|
|
|
|
|
reducing log file size in databases