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 |
|
KimJ
Starting Member
38 Posts |
 Posted - 2005-02-04 : 11:54:14
|
| Hi Everyone -I've got an issue with a transaction log being over 60gigs. Apparently the transaction log hasn't been backed up (?). Now we don't have any disk space to back up the log.Is there a way to truncate it without backing it up. Any suggestions?Thanks in advance,Kim |
|
|
KimJ
Starting Member
38 Posts |
Posted - 2005-02-04 : 12:00:31
|
| should I try backup log mydatabase with truncate_only |
 |
|
|
TG
Master Smack Fu Yak Hacker
6065 Posts |
Posted - 2005-02-04 : 12:53:40
|
| Yes, that command will truncate the log without backing it up. Be One with the OptimizerTG |
|
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2005-02-04 : 14:07:33
|
| you will also have to shrink the logfile to free up space on disk.-ec |
|
|
|
KimJ
Starting Member
38 Posts |
Posted - 2005-02-04 : 14:57:06
|
| Thank you - I was in panic mode!I did truncate and then shrink the log file. You can be sure I won't let THAT happen again... |
|
|
|
|
|
|
Urgent help needed - transaction log