======Team Foundation Server====== =====Documentation===== **TFS 2010** \\ [[http://msdn.microsoft.com/en-us/library/ms253116(v=vs.100).aspx|MSDN - Managing Server Configuration with TFSConfig]] \\ [[http://msdn.microsoft.com/en-us/library/dd236910(v=vs.100).aspx|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:[[http://intovsts.net/2010/12/03/timeout-with-tfs2010-backuprestore-power-tool/|Into ALM with TFS - Timeout with TFS2010 Backup/Restore Power Tool]] \\ =====Moving TFS databases===== ====Official==== [[http://msdn.microsoft.com/en-us/library/ms404860(v=vs.100).aspx|MSDN - Visual Studio 2010 - Team Foundation Server Move Types]] \\ [[http://msdn.microsoft.com/en-us/library/ms252516(v=vs.100).aspx|MSDN - Visual Studio 2010 - Restore Data to a Different Server or Instance]] \\ [[http://msdn.microsoft.com/en-us/library/ms404869(v=vs.100).aspx|MSDN - Visual Studio 2010 - Move Team Foundation Server from One Hardware Configuration to Another]] \\ ====Blogposts=== [[http://blogs.msdn.com/b/jjameson/archive/2010/02/28/lessons-learned-moving-tfs-to-windows-server-2008-and-sql-server-2008.aspx?Redirected=true|MSDN Blogs > Random Musings of Jeremy Jameson > Lessons Learned Moving TFS to Windows Server 2008 and SQL Server 2008]] \\ [[http://nullabletype.com/2010/02/migrating-tfs-2008-data-tier-from-sql.html|NullableType - Migrating the TFS 2008 data tier from SQL Server 2005 to SQL Server 2008]] \\ [[http://weblogs.asp.net/dmckinstry/archive/2006/12/04/moving-tfs-databases.aspx|Ponder .NET - Moving TFS Databases]] \\