As part of a disaster recovery test of our TFS 2008 instance I hoped to restore our backups of the database (currently on SQL Server 2005) to SQL Server 2008.
I noticed a warning on MSDN that this could make a restore impossible.
Has this been done in the wild? What are the risks?
Best Answer
Your disaster recovery plan should never include an upgrade at the same time. It's prudent to make the upgrade first and then plan your disaster recovery plan. Waiting for a recovery opportunity could spell trouble.
That being said, as long as you're using the latest service packs, TFS 2008 is fully supported on SQL Server 2008 now.
Buck Hodges is a definitive TFS guru. Here's what he says:
http://blogs.msdn.com/buckh/archive/2009/04/09/tfs-2008-supports-sql-2008-sp1.aspx