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 |
|
lebedev
Posting Yak Master
126 Posts |
 Posted - 2007-01-08 : 19:09:17
|
| Hi,I have an interesting problem here. I am running SQL Server 2005 and have a large database. After running some scalability tests over the weekend my MDF file size went up to 25GB and LDF file size went up to 27GB filling up all available disk space. I didn't do any backups, so it is understandable why the LDF file size is so large.Now I am trying to shrink the LDF file. However, DBCC LOGINFO indicated that all LVFs within the LDF are active (Status = 2). I detached the database to make sure no active connections exist and ran CHECKPOINT, but still DBCC LOGINFO lists all LVFs with status 2. Since all LVFs are up to date I can't shrink my LDF file.Why are all LVFs still active after detach/attach and checkpoint?How can I shrink the LDF file?Thanks.Alec |
|
|
lebedev
Posting Yak Master
126 Posts |
Posted - 2007-01-08 : 19:32:22
|
| I am closing this thread, because this thread answered my question http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=56434. |
 |
|
|
|
|
|
Shrinking 27GB LDF file (solved)