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 |
|
keithc1
Yak Posting Veteran
88 Posts |
 Posted - 2004-07-01 : 14:57:08
|
| Having a problem using DBCC Shrinkfile as follows to shrink a transaction logfile. Can someone let me know what I need to do to shrink the log file thanks.Runningdbcc shrinkfile ('TranLogFile',100, truncateonly) I get the following error messageCannot shrink log file 2 (TranLogFile) because all logical log files are in use.DbId FileId CurrentSize MinimumSize UsedPages EstimatedPages ------ ------ ----------- ----------- ----------- -------------- 9 2 381600 32000 381600 32000Keithc MCSE MCSA |
|
|
keithc1
Yak Posting Veteran
88 Posts |
Posted - 2004-07-01 : 17:58:31
|
| Going to answer my own question here. I went ahead and issued a BACKUP LOG LogName WITH TRUNCATE_ONLY and after that i was able to resolve the above error.Keithc MCSE MCSA |
 |
|
|
|
|
|
DBCC Shrinkfile