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 |
|
funketekun
Constraint Violating Yak Guru
491 Posts |
 Posted - 2007-08-30 : 14:51:19
|
how do you truncate the .LDF file if it's in simple recovery model?  =============================http://www.sqlserverstudy.com |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2007-08-30 : 18:11:35
|
| dbcc shrinkfileCODO ERGO SUM |
 |
|
|
Westley
Posting Yak Master
229 Posts |
Posted - 2007-08-30 : 22:25:31
|
| or you can do the backup tran <dbname> with truncate_only if you only want to truncate the log not shrinking it |
|
|
|
|
|
|
truncate log