View Single Post
  #1 (permalink)  
Old January 15th, 2009, 12:44 PM
sbunce5454 sbunce5454 is offline
Registered User
Join Date: Jan 2009
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Post Backup and Recovery Chapter Question

This chapter suggests that we use a SQL Maintenance plan to backup TFS databases.

The problem is that these 11 TFS databases are dependent on each other. Therefore, isn't it true that they need to be backed up as a unit (atomically)?

Is it possible to create a SQL Maintenance plan that guarantees this? If so, how?

If not, what is the correct way to ensure that this requirement is met? Should we use marked transactions?