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 |
|
kphelps
Starting Member
1 Post |
 Posted - 2005-05-12 : 16:57:40
|
| When I try to shrink my transaction log I get the following message."Cannot shrink log file 2 (DBAProd_Log) because all logical log files are in use. [SQLSTATE 01000] (Message 9008)" But I ran dbcc opentran and there are not open transactions. And even when go so far as to take the database offline and bring it back online I still get the same error message. Please help.Thanks,Katherine Phelps |
|
|
bakerjon
Posting Yak Master
145 Posts |
Posted - 2005-05-12 : 19:25:29
|
| Try backing up the transaction log to disk or doing a backup log <dbname> with truncate_only if you don't need to restore the transactions ever.Now I know, and knowing is half the battle!http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=48013 |
 |
|
|
|
|
|
Shrink transaction log fails