This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(150.4, 17%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EP%3C/text%3E%3C/svg%3E)
Hello,
I am having difficulties to migrate sql server TFS databases from old server to new server as couldn't access TFS after migrating.
We have Sql Server 2012 which is hosting TFS and now we are trying to migrate it to new Sql server 2017 and installing TFS 2018 but after migrating TFS database, we are having issue to access TFS.
We have similar permission setup what we have in current environments.
We tried following steps:
We are trying migrate following databases:
Not sure what's the best way to migrate TFS databases with TFS Installation.
Thanks for your help!
Hi @pdsqsql ,
Did you post your issues in TFS forum as DSPatrick mentioned? People there will help you more effectively.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
The product group for Azure DevOps / TFS actively monitors questions over at
https://developercommunity.visualstudio.com/report?space=21&entry=problem
https://developercommunity.visualstudio.com/report?space=22&entry=problem
--please don't forget to upvote and Accept as answer if the reply is helpful--
To add to what DSPatrick says: TFS is a server application on its own, so this is why you primarily should ask in a TFS forum and not in an SQL Server forums. The only reason to ask in an SQL forum would be that you have isolated the problem to related to SQL Server only.
I would also advice you what when you post in a TFS forum to provide more details. You cay you cannot access TFS, but people can't help you if you don't specify more exactly what happens. What error message do you get? What URL do you use etc?
Thanks Erland. and Patrick.
I understand your concern and agreed with your views.
I posted here because if someone has migrated sql server database for TFS and they might provide any feedback.
As a Sql Server DBA, mostly we have to migrate/ restore databases for Sql server from one environment to another but this time i am having issue with TFS databases (Sql Server) which i used Backup and restore method but TFS application having issue.
We received error when trying to access from TFS admin console:
TF400876: Could not find the partition for host 0EC13D06-3868-4D27-AFCB-F159473899E0
Should I restore all the TFS_ and WSS_ databases?
Thanks once again for your help!
Better to ask experts in dedicated forums I linked above.
--please don't forget to upvote and Accept as answer if the reply is helpful--
As DS says, this is not the place to ask for error messages from TFS.
I seem to recall that TFS has its own utilities for copying the TFS Project Collection around. I don't recall, if this includes of copying the databases, but I kind of guess it does.
I did some (very) quick googling, and I found https://devblogs.microsoft.com/premier-developer/move-or-clone-tfs-from-one-hardware-to-another-in-tfs-2017-2018/
I don't think it will answer all your questions, but it may give you an idea what you should not do.