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 |
|
jhun_garma
Starting Member
15 Posts |
 Posted - 2002-04-26 : 04:59:25
|
| I have a problem i can't seem to shrink the transaction log of my database. I have a database whose data file is only 600 MB, while my transaction log is a whopping 6 gig the error is :"Cannot shrink log file 2 (Cocosystem_Log) because all logical log files are in use."I do not wish to detach the database and then delete the transaction log manually is there any way around this...thanks in advancejhun |
|
|
YellowBug
Aged Yak Warrior
616 Posts |
Posted - 2002-04-26 : 06:01:37
|
| Did you try truncating the Transaction Log? BACKUP LOG dbname WITH TRUNCATE_ONLY Aside: If this is a database that does not require the recovery options that backing up the transaction log provides, consider setting the option to truncate log on checkpoint in futureEXEC sp_dboption 'TOPS', 'trunc. log on chkpt.', 'TRUE' |
 |
|
|
|
|
|
can't shrink transaction log file