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 |
|
juicyapple
Posting Yak Master
176 Posts |
 Posted - 2008-02-12 : 20:40:32
|
Hi, when I shrink log file, I get the error:dbcc shrinkfile (testingdb_log,1) Cannot shrink log file 2 (testingdb_log) because all logical log files are in use.and after I truncate the log file, then shrink log again, it is completed successfully. Why would this happen? |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-02-12 : 23:37:55
|
| Since there were logged transactions. |
 |
|
|
juicyapple
Posting Yak Master
176 Posts |
Posted - 2008-02-13 : 00:47:57
|
| Sorry, I can't get your mean... |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-02-16 : 14:51:50
|
| You have to truncate committed transactions and move remains to beginning of the file. Try shrink it in gui, there are options for those. |
|
|
|
|
|
|
Shrink Log File Error