User Tools

Site Tools


microsoft:tfs

Team Foundation Server

Documentation

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

Blogposts

microsoft/tfs.txt · Last modified: 2012/12/24 13:30 by bas