Upgrade SQL 2008 to R2

Question

I am going to be moving TFS 2010 to new servers, and the MSDN guide says to make sure software versions are the same.  My current server is SQL 2008, and I need to upgrade it to 2008 R2 to match the new server.  Are there any issues upgrading a TFS 2010 server from SQL 2008 to SQL 2008 R2?

Answer 1

Hi Cliff,

TFS 2010 works with SQL Server 2008 R2. You can also check out this thread:
http://social.msdn.microsoft.com/Forums/en-US/tfssetup/thread/fbbcd4cd-f3d5-4436-b139-a8c39e8e6fdd

Catherine Sea
Version Control Software | TFS Hosting Service

Answer 2

Thank you.  I found plenty of threads for new installs but nothing about an upgrade in place.

Answer 3

Hi Cliff,

i don't see any issues in upgrading SQL 2008  to SQL 2008 r2 with TFS 2010. Before upgrading the SQL, just take the backup of the databases.

Thanks,

Chandra

Answer 4

Hi Cliff,

Thanks for your post!

You can refer: http://msdn.microsoft.com/en-us/library/ms144267.aspx [How to: Upgrade to SQL Server 2008 R2 (Setup)].. This has a detailed instructions for version upgrade..

As Chandra said, before upgrading SQL 2008  to SQL 2008 R2, you need to backup of the databases.

Best Regards,

---

Cathy Kong [MSFT]
MSDN Community Support | Feedback to us