Monthly Archives: September 2008

truncate SQL 2005 Log file

Unlike SQL 2000, you can't conveniently just truncate the transactionlog. But you can do this: 1. Highlight the database-> Tasks->Detach..-> Click OK 2. Go to log file folder -> rename the xxx_log.ldf to something else 3. Highlight Databases->Attach…-> Click Add … Continue reading

Posted in SQL | Leave a comment