Friday, October 29, 2010

Could not create a new TFS project

Last week I had to create a new Team Project in Team Foundation Server. Easy job of course, until the project creation failed while adding a new Sharepoint site. In the error log, I found the following information:

The transaction log for database 'WSS_Content' is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databases" Query text (if available): "{?=call proc_CreateWeb(?,?,?,?,?,?,?,?,?,?,?,?,?,?)}

Aha, that’s a meaningful error message. I just had to shrink the transaction logs. I looked at one of my previous posts( Truncate your SQL Server Transaction Logs) and tried to execute the following statement inside SQL Server Management Studio:

   1:  USE WSS_Content_Log
   2:  GO     
   3:   
   4:  BACKUP LOG 'WSS_Content_Log' WITH TRUNCATE_ONLY
   5:   
   6:  DBCC SHRINKFILE('WSS_Content_Log', 1)   


But strangely enough this command failed. Instead the following error message was returned:


‘truncate_only' is not a recognized BACKUP option.


I found out that this is no longer a supported command in SQL Server 2008. I had to remove the log chain by switching to simple recovery mode. I completed the job by executing this last command:

   1:  USE WSS_Content_Log
   2:  GO     
   3:   
   4:  DBCC SHRINKFILE('WSS_Content_Log', 1)   

No comments: