terryj30 (2/9/2009)
I really wound not recomend this but it will create you a new tranlog that is empty.
I would not recommend that under any circumstances. It's the quickest way to get a corrupt and unusable database.
Or back up the db in simple and dump the log with no_log
In simple recvery,no backup log is necessary. A checkpoint truncates the log.
Backup log ... with no_log is no longer available in SQL 2008. It will throw an error saying unrecognised backup option.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability