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 |
|
ferrethouse
Constraint Violating Yak Guru
352 Posts |
 Posted - 2012-06-06 : 13:49:30
|
| I thought that when in simple mode if you did a backup that it would truncate your transaction logs but mine stay the same size.Likewise, when in FULL recovery mode I thought they were truncated whenever the Tlogs were backed up (hourly in our case) but again that doesn't seem to be happening for us.Is there something that I have to make happen after a backup to do this? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
ferrethouse
Constraint Violating Yak Guru
352 Posts |
Posted - 2012-06-06 : 14:41:55
|
| In this case I am deleting clients from the database which is causing them to bloat massively (to 100 gigs from a "normal" size of 15 gigs). So I need to shrink them down for disk space reasons.Thanks for the reply - it makes sense now. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
size of ldf files not shrinking after backup