Table of Contents

Team Foundation Server

Documentation

TFS 2010
MSDN - Managing Server Configuration with TFSConfig
MSDN - The Team Foundation Administration Console

Why not Simple recovery model on TFS databases?

So, I was thinking about setting the recovery mode of the TFS databases to Simple permanently and switching to a nightly full backup each day. I assumed that we will always be able to do a restore to one of those full backups (maximum loss of data = 1 day) … No! Just don’t do this! The Backup/Restore Power Tool relies on SQL marked transactions to keep consistency across the TFS (and dependency products) databases. The SQL marked transaction implementation in the Backup/Restore Power Tool requires the SQL recovery mode to be set to Full. Thanks to the TFS product team for making this clear to me! Switching permanently to a Simple recovery mode could possibly result in a rollback to inconsistent TFS databases.

Source:Into ALM with TFS - Timeout with TFS2010 Backup/Restore Power Tool

Moving TFS databases

Official

MSDN - Visual Studio 2010 - Team Foundation Server Move Types
MSDN - Visual Studio 2010 - Restore Data to a Different Server or Instance
MSDN - Visual Studio 2010 - Move Team Foundation Server from One Hardware Configuration to Another

Blogposts

MSDN Blogs > Random Musings of Jeremy Jameson > Lessons Learned Moving TFS to Windows Server 2008 and SQL Server 2008
NullableType - Migrating the TFS 2008 data tier from SQL Server 2005 to SQL Server 2008
Ponder .NET - Moving TFS Databases