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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-01-21 : 08:50:46
|
| Jim writes "Hello, I have some quesitons regarding the *_log.ldf files. Specifically the size of these files and what their function is. I've noticed that these files tend to grow to enormous sizes. For Example DBase1_log.ldf is approching 15GB in size. This database is only a few months old. I can't look at the file because sql says that it is in use. I'm on a total guess here but are these files the transition logs? Any information you can provide as far as backing up and deleting, or somehow truncating these files to a much much! smaller file. Thank you so much for your help. Respectfully, Jim Myers" |
|
|
Page47
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2003-01-21 : 08:55:53
|
| Bingo! Those are the transaction logs. Read up in Books Online about what they do and how to admin them.Jay White{0} |
 |
|
|
ValterBorges
Master Smack Fu Yak Hacker
1429 Posts |
Posted - 2003-01-21 : 08:57:22
|
| Do you run backups? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-01-21 : 13:39:47
|
| If your recovery model is set to FULL, you should start backing up the transaction log. If you do not need to restore to a point in time, then change the recovery model to SIMPLE. To check your recovery model, just go to the properties of the database in Enterprise Manager. Check under Options for recovery model. You will also need to shrink the file in order to gain the disk space back. Look up DBCC SHRINKFILE in BOL. |
|
|
|
harshal_in
Aged Yak Warrior
633 Posts |
Posted - 2003-01-21 : 23:52:39
|
quote:
If your recovery model is set to FULL, you should start backing up the transaction log. If you do not need to restore to a point in time, then change the recovery model to SIMPLE. To check your recovery model, just go to the properties of the database in Enterprise Manager. Check under Options for recovery model. You will also need to shrink the file in order to gain the disk space back. Look up DBCC SHRINKFILE in BOL.
this size of transaction log must surely have affected the performance of u'r database I think this is the time u should follow tduggan's advice.Expect the UnExpected |
|
|
|
|
|
|
*_log.ldf files