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     
   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     
   4:  DBCC SHRINKFILE('WSS_Content_Log', 1)   

1 comment:

Priya Kannan said...

This information really worth saying, i think you are master of the content and thank you so much sharing that valuable information and get new skills after refer that post.
SQL Server Training in Chennai