Skip to main content

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)
Labels:

Popular posts from this blog

Kubernetes–Limit your environmental impact

Reducing the carbon footprint and CO2 emission of our (cloud) workloads, is a responsibility of all of us. If you are running a Kubernetes cluster, have a look at Kube-Green . kube-green is a simple Kubernetes operator that automatically shuts down (some of) your pods when you don't need them. A single pod produces about 11 Kg CO2eq per year( here the calculation). Reason enough to give it a try! Installing kube-green in your cluster The easiest way to install the operator in your cluster is through kubectl. We first need to install a cert-manager: kubectl apply -f https://github.com/cert-manager/cert-manager/releases/download/v1.14.5/cert-manager.yaml Remark: Wait a minute before you continue as it can take some time before the cert-manager is up & running inside your cluster. Now we can install the kube-green operator: kubectl apply -f https://github.com/kube-green/kube-green/releases/latest/download/kube-green.yaml Now in the namespace where we want t...
Read more

Azure DevOps/ GitHub emoji

I’m really bad at remembering emoji’s. So here is cheat sheet with all emoji’s that can be used in tools that support the github emoji markdown markup: All credits go to rcaviers who created this list.
Read more

.NET 9 - Goodbye sln!

Although the csproj file evolved and simplified a lot over time, the Visual Studio solution file (.sln) remained an ugly file format full of magic GUIDs. With the latest .NET 9 SDK(9.0.200), we finally got an alternative; a new XML-based solution file(.slnx) got introduced in preview. So say goodbye to this ugly sln file: And meet his better looking slnx brother instead: To use this feature we first have to enable it: Go to Tools -> Options -> Environment -> Preview Features Check the checkbox next to Use Solution File Persistence Model Now we can migrate an existing sln file to slnx using the following command: dotnet sln migrate AICalculator.sln .slnx file D:\Projects\Test\AICalculator\AICalculator.slnx generated. Or create a new Visual Studio solution using the slnx format: dotnet new sln --format slnx The template "Solution File" was created successfully. The new format is not yet recognized by VSCode but it does work in Jetbr...
Read more
OSZAR »