Troubleshooting a full transaction log.

While trying to create a new TFS project, I was running into issues creating the SharePoint site. I noticed that the SQL Server log had the following message

"The transaction log for the database 'WSS_Content' is full. To find out why the space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databases".

So I ran the following query

select [name], [log_reuse_wait], [log_reuse_wait_desc] from sys.databases

and noticed that log_reuse_wait_desc had the value set to LOG_BACKUP.

This meant that a Log backup operation is preventing the truncation of log files and consequently its reuse. So I explicitly performed a Transaction Log backup through Management studio. With that the error message disappeared and the transaction log file became reusable.

Ref:
Troubleshooting a Full Transaction Log (Error 9002)

How to: Back Up a Transaction Log (SQL Server Management Studio)