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 |
|
gregoryagu
Yak Posting Veteran
80 Posts |
 Posted - 2008-08-05 : 10:30:09
|
| I get this message when shrinking a database:'Cannot shrink log file 2 (Mesa_Log) because all logical log files are in use.'I have searched on this error message, and the advice is to check for open transactions which I have done and there are none. I even take the database offline, and back online again, and again, the same message. Yet my log file is over one gig and it should be about 35 megs. The logfile increase is when I dropped all indexes and recreated them. The MDF shrinks to about half of the former size, but the log file is resistant to shrinkage.Oh what to do?Greg |
|
|
sakets_2000
Master Smack Fu Yak Hacker
1472 Posts |
Posted - 2008-08-05 : 12:05:00
|
| Check for the default size of ldf. Did you try truncating all logs ??? |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-08-07 : 23:24:45
|
| Why shrink it? It'll go back to 1gb when you rebuild index again, and 1gb is nothing now. |
|
|
|
gregoryagu
Yak Posting Veteran
80 Posts |
Posted - 2008-08-15 : 16:42:03
|
| Thanks very much for the responses.Greg |
|
|
|
|
|
|
ShrinkDatabase