The admininistration guide has a topic for just this activity, and I believe it has been updated since RTM.

Have you seen the How-to on server migration (and if so, can you check out the latest version and see if the Sharepoint-related sections are better than the one you were using)?

The guide is available here: http://www.microsoft.com/downloads/details.aspx?familyid=2AED0ECC-1552-49F1-ABE7-4905155E210A&displaylang=en (Note that you probably need to save the guide CHM file, then unblock it, before you'll be able to view it correctly).

The section you want is "How to: Restore Team Foundation Server Data to a Different Server" - I got to via TF Admin Walkthroughs -> Backing up and Restoring a Team Foundation Server (there's a link to the howto in backup & restore #4.

Let me know if this doesn't help (or is "old news" to you) and we'll dig in farther.

I followed those instructions the 1st time I went through and Sharepoint came out trashed. I might have missed a step, but after talking with a few more people that know more about Sharepoint than I do I don't think so. The problem is with restoring the config database, it has all sorts of references to the original server and when you try to do anything and it can't access that original database server it blows up. I fixed it like this, which I think is along the lines of what the instructions were going through:

1. When restoring databases skip the STS_Config_TFS and STS_Content_TFS databases
2. Go into Sharepoint Administration, manage the content databases and remove the STS_Content_TFS database that was installed by default
3. Restore only the STS_Content_TFS database
4. Add in the STS_Content_TFS database through Sharepoint Administration

FYI, I am going to run this again in a test environment just to make certain, but I'm pretty certain this is correct.

hi guys,

well i experienced moving the server to new one.. at first i had a problem but its just a version problem in my SQL (coz i havent installed the SP1). but i manage to finish it and now all is smooth and clean :)

just follow this (Step by step):

http://msdn2.microsoft.com/en-us/library/ms404869.aspx

I'm sorry about the delay in getting back to you, job change sort of had me preoccupied.

Short answer, no you can fix it but its not all that nice.

Long answer, uninstall TFS, delete the databases (make sure you have backups!), and reinstall, this time not restoring the config database. I had to do this when I first discovered the problem and although a pain, wasn't bad if you did it right then (once again, I am sorry for the delay). If you kept on going while Sharepoint didn't work this would still work, as long as you used the most up to date backups instead of the originals.

I have never tried this, so take this as it is.

It should be possible, following pretty closely with the Migrating TFS to a New Hardware instructions. The only problem outside of this will be with the ID's that are used to run TFS when it was originally setup and the existing users since they will no longer be accessible after the migration. You can change the ID's used with TFS by using the TFSAdminUtil command line tool. The users you will have to resolve manually.

http://msdn2.microsoft.com/en-us/library/ms404883.aspx

:)