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 |
|
javaherian
Starting Member
1 Post |
 Posted - 2009-09-04 : 13:01:19
|
| Hi,What is the relation between Transaction Log and .ldf file?When I backup the Transaction Log, the size of the .ldf file remains the same, shouldn't it lower the size the of .ldf fileThanks |
|
|
acollins74
Yak Posting Veteran
82 Posts |
Posted - 2009-09-04 : 14:01:26
|
| you got to shrink it, if you want it to get smaller. shrink it. |
 |
|
|
shah429
Yak Posting Veteran
52 Posts |
Posted - 2009-09-04 : 17:38:14
|
| Don't ever shrink the log file unless you really need to. Are you having any performance issues? |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-09-04 : 21:35:25
|
| Under Full Recovery Model, Virtual inactive log space can be freed by transaction log backup but can't free active virtual space.Under Simple Recovery model, log space is freed as soon as Checkpoint occurs.There are numerous articles regarding managing log space here.please search for it. |
|
|
|
|
|
|
Transaction Log