Replicating a collection to a different TFS 2010 server

Question

Hi,

Our company requires a usable copy of our artner companies source code.  Both TFS servers are 2010 and seperated by the public internet.  So I am wondering what would be the best way to get a Disaster revocery or SQL DB copy of the source code?

The TFS proxy has been mentioned in some threads but this doesn't seem like a valid method.  Also the TFS integration APIs looks like a possiblity byt I have no programming experience.  I do however have some SQL knowledge and some Administration in TFS.

Does anyone have any ideas?

James

Answer 1

Hi James,

Thank you for your post.

One import thing want to confirm with you. Do the collection can work properly now? Or, is the database of this collection is good or corrupt?

If the collection cannot work properly in this TFS, move to another TFS, it cannot work too. The data of this collection is damaged.

If the collection can work properly, you can follow this article Move a Team Project Collection, to move collection to another TFS instance. Note, please do not skip any step, otherwise, the collection may not work in the other TFS.

Regards,

---

Lily Wu [MSFT]
MSDN Community Support | Feedback to us

Answer 2

Hi Lily,

Thanks for your reply, this is one of my options but I think that I need to replicate another way as the business at the other end still needs to use there TFS server.

Would I be able to move the collection and then somehow replicate changes from 1 to the other say at a SQL level?

Please let me know

Answer 3

Hi James,

By "replicate changes from 1 to the other say at a SQL level?", what do you mean by this? I am sorry to say i am not quite understand the exact meaning.

By Move a Team Project Collection, the collection data can use in both of TFS servers. In general, it back up the collection database in one SQL instance, then restore it in another SQL instance.

Regards,

---

Lily Wu [MSFT]
MSDN Community Support | Feedback to us

Answer 4

Hi Lily,

Thanks for the reply.  OK, say I copy the SQL db from one server to another and then add the collection into the new TFS server 1 time and its all fine.  If the collection on the source TFS server is still used the collection on the other TFS server will go out of date, so I would need to copy it again.

What I am saying is could I script a SQL backup from 1 sql to another or would I need to continue having to add a new collection to get the updates.

I hope this makes sense?

James

Answer 5

Hi James,

If you want to move TFS collection database from one TFS to another first, then want to sync data between those TFS, the problem changes to how to sync two sql instances' data, i suggest you go to SQL forum for help.

Regards,

---

Lily Wu [MSFT]
MSDN Community Support | Feedback to us