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 |
|
im1dermike
Posting Yak Master
222 Posts |
 Posted - 2009-02-02 : 09:24:00
|
| I came in to work today and one of my databases now has an LDF log file that is 200 gigs. The database is extremely small. It has a dozen or so functions, no views, and about 15 small tables. How did it get so big? Also, how do I resolve this situation? I tried backing it up, deleting it, and then restoring, but it restores the log file again to an even larger size. |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
|
|
saurabhsrivastava
Posting Yak Master
216 Posts |
Posted - 2009-02-02 : 12:25:45
|
| Check this out: http://support.microsoft.com/kb/873235 |
 |
|
|
|
|
|
Enormous log file out of no where