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 |
|
mdelgado
Posting Yak Master
141 Posts |
 Posted - 2002-07-16 : 09:32:02
|
| Hello all....I'm currently having a problem Shrinking the log Files on one of my Databases. When I run:DBCC SHRINKDATABASE (buckatdropshipper, 10)GOI get the following message:Cannot shrink log file 2 (buckAtDropShipper_Log) because all logical log files are in use.DbId FileId CurrentSize MinimumSize UsedPages EstimatedPages ------ ------ ----------- ----------- ----------- -------------- 7 2 641408 63 641408 56(1 row(s) affected)DBCC execution completed. If DBCC printed error messages, contact your system administrator.The current size of the log file is 5 gigs but the actual space being used is 58 megs.How Can I free up all that extra space?thanks... |
|
|
TrondBjerkan
Starting Member
6 Posts |
Posted - 2002-07-16 : 10:57:03
|
| I have had similar problem and used the following (on MSSQL2000)backup log buckatdropshipper with no_logdbcc shrinkdatabase (@buckatdropshipper, truncateonly)- Trond |
 |
|
|
|
|
|
Shrinking Log Files.