SQL Log full

Hate getting that pesky SQL Log is full error? It only takes a minute to fix. Run:

BACKUP LOG <DatabaseName> WITH TRUNCATE_ONLY

Then, right click on your database, select Tasks -> Shrink -> Database.

Then click OK and you are done.

Thanks to Pinal at: http://blog.sqlauthority.com/2006/12/30/sql-server-shrinking-truncate-log-file-log-full/