We tried moving a TFS Project Collection from one TFS 2010 server to another.
TFS adminisitrator received the following error message.
TF254078: No attachable databases were found on the following instance of SQL Server: MyServerName. Verify that both the name of the server and the name of the instance are correct and that the database was properly detached using the detach command in the Team Foundation Administration Console.
I assmumed we did not need to prepare the database instance in the target server since it already contained a TFS Project Collection. I assumed that going up in a SQL Server edition was acceptable.
Are my assumptions valid? What could be the cause of not being able to attach to the new TFS Server?
btw, I created this post on ServerFault originally Mirror in Serverfault, but it generated very little interest there.
Make sure both the TFS service level and SQL server versions match the previous server.
You can verify this information using SQL Management Studio > Databases
> Tfs_Configuration
or Tfs_DefaultCollection
> Properties
> Extended Properties
Note these properties:
TFS_PRODUCT_VERSION 10.0.40219.1 TFS_SCHEMA_VERSION Microsoft Team Foundation Server 2010 (SP1) TFS_SERVICE_LEVEL Tfs2010.SP1.KB2182621.P#1
Also note the SQL version under <database instance name>
> Properties
> General
Version 10.50.2500.0
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With