Friday, April 28, 2017

TF246017: Team Foundation Server could not connect to the database

A colleague forwarded me the following error message:

clip_image002

The problem occured when he tried to create a branch, but only on this specific project we had issues.

Time to log on the TFS server and check the Event Log. There I found the following error message:

DESCRIPTION: SQL Server Assertion: File: , line=951 Failed Assertion = 'IS_OFF (BUF_MINLOGGED, m_buf->bstat) || pageModifyType != PageModifyType_Contents || GetPagePtr ()->IsTextPage ()'. This error may be timing-related. If the error persists after rerunning the statement, use DBCC CHECKDB to check the database for structural integrity, or restart the server to ensure in-memory data structures are not corrupted.

This error message brought me to the following Connect ticket: https://connect.microsoft.com/SQLServer/feedback/details/3005568/sql-server-2016-merge-statement-fails-when-running-db-in-simple-recovery-model

I first tried to install all possible updates but no luck, the issue remained. Then I saw that in the ticket they mention switching to the Full recovery model. I tried that and it seemed to work.

Now

5 comments:

Mahalyasree said...

The given information was very excellent & Great tips, and awesome way to get exert tips from everyone, not only i like that post all peoples like that post, because of all given information was wonderful and it's very helpful for me.
Interior Decorators in Chennai
Home Interior Designers in Chennai
Home Interiors in Chennai

Gopi Krishna said...

AngularJS is a toolset for building the framework most suited to your application development. It is fully extensible and works well with other libraries. Every feature can be modified or replaced to suit your unique development workflow and feature needs. Read on to find out how.

AngularJS Training in Chennai
AngularJS Training Institute in Chennai

AngularJS Certification Training in Chennai

Natasha Mary said...

Great walkthrough, thanks!

In Sign said...

Insign is the best Interior Designers and Decorators in Chennai

Interior Designers in Chennai
Interiors in Chennai
Good Interior Designers in Chennai

Ensileta Interiors said...

Nice blog information.Thanks for sharing this...
Top 10 Interior Designers in Chennai
Top Interior Design Companies in Chennai