TFS 2010 Power Tools + TFS Backup and Restore Hands on Lab

[Update: 23rd Sep 2010. Microsoft recommend NOT backing up SharePoint with the Power Tool until the Power Tools are updated. More info]

—————————–

Last week Microsoft released an updated version of the Team Foundation Server 2010 Power Tools. This new (September) release includes a new Power Tool as well as updates to three of the existing Power Tools.

  • NEW – Team Foundation Server Backups
  • Updated – Microsoft Team Foundation Server 2010 Best Practices Analyzer
  • Updated – Team Explorer Enhancements
  • Updated – Team Foundation Power Tool (TFPT.EXE)

You can download and read more about the new Power Tools on the download page on Visual Studio Gallery. If you would like to know more about the new TFS Backup Plan Power tool, read-on…

I wanted to use this blog post to provide a quick pictorial run through of the new Team Foundation Server Backups power tool and to make available a Hands-On Lab I have written around the new TFS Backup Power Tool.

Hands On Lab

If you’d like to walk through a Hands-On Lab exercise to see how the TFS Backup and Restore works, you can download it here. (11 page PDF, ~623Kb)

This Hands-On Lab has been written and included in my TFS 2010: Configuration and Administration course. If you’d like to know more about the course, you can read more on the course webpage.

Pictorial walkthrough

If you’d just like to skim through some screenshots to get a feel for the TFS Backup Power tool, keep scrolling.

Creating a TFS Backup Plan in pictures.

After installing the Power Tools, Create a Backup Plan through the Team Foundation Server Console

Figure1

The TFS Backup Plan is a Wizard based UI.

Figure2

Provide a UNC path to where you want the database backup files to go

Figure3

Choose how long you want to keep each backup set for.

Figure3b

Decide if you want to backup the SharePoint and SQL Reporting Services databases.

Figure4

Provide details of the account to use

Figure5

If you’ve setup SMTP details in TFS, provide an email address for TFS Backup failure notifications to be sent to.

Figure6

Choose how frequently you want the backups to occur.

Figure7

The schedule you choose can be quite specific.

Figure7b

Confirm the settings you have entered.

Figure8

Keep your fingers crossed that the Readiness Checks all pass.

Figure9

Finally your Backup Plan has been created.

Figure10

All done.

Figure11

You can view your TFS Backup plan from the Team Foundation Administration Console. You can also trigger a manual backup quickly and easily.

Figure12

Here’s a manually trigger backup in progress.

Figure14

The backup has completed successfully.

Figure15

Here’s a sample of what will appear in the backup location.

Figure13

Restoring from a backup in pictures.

Kick off the Restore wizard from the Start menu.

Figure16

Provide the UNC path to where the backup sets are stored.

Figure17

Provide the name of the SQL Server where you want to restore each database to.

Figure18

Check your details are correct.

Figure19

The Readiness Checks have all passed.

Figure20

The restore in action.

Figure21

Restore is all done.

Figure22Figure23

So now you’ve got no excuse for not having up to date backups of your TFS Server databases.

About these ads

About anthonyborton

Anthony Borton is a Microsoft MVP in Visual Studio ALM. He is the principle ALM Consultant/Trainer at Enhance ALM, based in Brisbane, Australia.
This entry was posted in HowTo, VS2010 and tagged , , , . Bookmark the permalink.

19 Responses to TFS 2010 Power Tools + TFS Backup and Restore Hands on Lab

  1. Thanks for putting this together!

  2. Paul Meh says:

    I’m new to TFS and was searching the web yesterday and I came across this article and another MSDN article that does not refer to TFS Backup Plan at all:

    http://msdn.microsoft.com/en-us/library/ms253070.aspx

    This article is from March 2011, so it is very current. Would your method back everything up as it is described in the above article?

    Thanks,

    Paul

    • Hi Paul,

      The results would be similar but I you would still need to backup the SQL Reporting Services encyption key yourself and you’d need to do the things listed under the heading “Back Up Additional Lab Management Components” yourself.

      Cheers
      Anthony

  3. Sam says:

    Thank you for the great tutorial !

  4. Pingback: TFS 2010: Changing Template for an Upgraded Team Project – Geeksco Blog

  5. Usman Javaid says:

    Great post. I have a question:

    We are working on business continuity (disaster recovery) of our mission critical servers and TFS is among one of the server which in case of a disaster needs to be restored on urgent basis. Please tell me how we can setup backups using TFS power tools so that we can quickly restore to another server in case of any disaster / hardware failure.

  6. Sri kommana says:

    can I perform this backup without giving NETWORK_SERVICE any permissions to the backup folder(without using network_service account ) ? Or using Network_Service is mandatory ?

  7. Paulo Moreno says:

    Hi, I have installed TFS 2010 in a virtual server, it’s possible use TFS Backup Plan in a local directory?

    • Hi Paulo,

      The powertool has been designed to only accept a UNC path, not a local directory. I have not tried creating a shared folder on the local machine and trying to specify that in the backup powertool. That said, you really want to make sure your backups are NOT on the actual TFS server. If the TFS VM becomes corrupted, you would be able to get to your backups if they are stored on the same VM.

      Cheers

      Anthony

  8. LVPrasad Y says:

    great Post, helped me alot.

  9. ulfelf says:

    Hope you still is answering here….

    First, thanks for a great article!

    Second: Where are these jobs stored?
    I can’t find them in the SQL server, itself, so are they stored somehow, somewhare in Tfs_Configuration database?

    • Hi ulfelf,

      I don’t have a TFS server nearby with the Backup Powertool configured to look closely for you. If my memory serves me, the Backup Powertool adds two scheduled tasks to the Windows Scheduler to do the backup and cleanup old backups. Have a look at these scheduled tasks and that should point you in the right direction.

      Cheers
      Anthony

      • ulfelf says:

        Thanks !
        Found them there.

        Is there a way to check the actual T-SQL for the steps, both backup and delete?

  10. cliff says:

    Does this process also work when restoring to a different server?

  11. Jason says:

    Anthony,

    I have created a backup plan for 2012 and verified successfully. I ran the backup now and it succeded. My issue is that all my scheduled backups return an error on the last run result column. The logs only contain a header and no other information. Nothing is writing to the backup location. Have you seen anything like this ?

    Jason

    • Hi Jason,

      This is not something I have seen. Can you provide more details about the exact error?

      Can you confirm which product versions you are using?
      – TFS 2012 with or without Update 1?
      – Which version of the Power Tools?
      – Which version of SQL Server? (Any Service Packs or CUs?)

      Thanks

      Anthony

      • Jason says:

        TFS 2012 without update 1 (trying to get good backup before updating)
        Powertools 2012
        SQL 2008 R2.

        I can run the backup now successfully. The scheduled backups however don’t write to the backup location and only leave an error.(Log only shows header info with no other details) I don’t see any other event errors in the backup time frame that might give more clues as to what is going on.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s