Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
hshaw
Starting Member
2 Posts |
 Posted - 2010-10-05 : 18:35:42
|
| Hi,We are running TFS in a virtual environment in a single server deployment. It has been working fine but all of a sudden a couple of our users are receiving the following error when attempting a merge:“Error TF30041: Team Foundation Server could not connect to the database. Contact your Team Foundation Server administrator”.The error in the event viewer states that it is an SQL problem:“Event ID 605, attempt to fetch logical page .. in database 2 failed. It belongs to allocation unit .. not to ..”If they attempt the merge on a sub directory it works fine.I have run DBCC checkdb and it does not report any errors.The SQL logs has the following errors:"Error: 605, Severity 21, State 3"Can someone help me please? We are running Server 2008 SP1 and SQL Server standard 2008 SP1Thanks,Daniel |
|
|
hshaw
Starting Member
2 Posts |
Posted - 2010-10-05 : 21:09:43
|
| I think I have narrowed it down to a tempdb issue. Is there a way for me to increase the size of the tempdb to test out a theory? |
 |
|
|
tosscrosby
Aged Yak Warrior
676 Posts |
Posted - 2010-10-07 : 16:59:52
|
| If you have disk space, right click on tempdb, properties and increase the size, either log or data, whichever is appropriate. Or use alter database (look in BOL). Something like:USE master;GOALTER DATABASE tempdb MODIFY FILE (NAME = tempdbdata, SIZE = 100MB);GO Is tempdb set not to autogrow? I always size tempdb to where I believe it should be and try to proactively monitor it and increase the size as neccessary. But I do still have the autogrow enabled. (I also have ample free disk space)Terry-- You can't be late until you show up. |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2010-10-08 : 04:24:33
|
| What's the exact version of SQL that you're running? (SELECT @@version)--Gail ShawSQL Server MVP |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2010-10-09 : 14:02:13
|
| I suspect you've run into this bug http://support.microsoft.com/kb/960770It's fixed in CU3, which I think is included in SP1 (check that), but you need to enable a traceflag for the problem to not reoccur. Double-check that this kb article matches your symptoms and, if it does check that you have the required build and enable the traceflag.p.s. the bug is not related to the size of tempDB. Increasing the size of the DB won't fix the problem.--Gail ShawSQL Server MVP |
|
|
|
|
|
|
|
|
SQL/TFS data corruption?