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 |
|
pelegk2
Aged Yak Warrior
723 Posts |
 Posted - 2006-02-02 : 15:53:37
|
| my log file is in size of almost 7 GB where the DB is in the size of9GB!!!!morethen that - i have change the recovery from full to bulkbut still no reduce!why is that?what can cause the log to become so big?thnks inadvancepelegIsrael -the best place to live in aftr heaven 9but no one wan't to go there so fast -:) |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-02-02 : 15:55:33
|
| DBCC DBREINDEX will cause this. You should not shrink the transaction log as it will just grow again next time the optimizations occur. So you'll receive a performance hit while it needs to grow again.We have some tlogs that are 1.5 times bigger than the database.Tara Kizeraka tduggan |
 |
|
|
|
|
|
log file on windows server 2003