Team
System

Visual Studio Team System: tips, tricks, and
techniques

Search

Go

Most Recent Items

Moving
your Team Foundation Server

A
Visual Guide to Backing Up a Team Foundation Server database

Team
System and Sarbanes-Oxley compliance

Team
Explorer now available for free download!

Why
doesn't check out also get latest?

Links

Let us help you
implement Team System!

FAQ: Team Foundation
Server

FAQ:
Team System Developer Center

Archives

June
2006 (1)

May
2006 (7)

April
2006 (6)

March
2006 (11)

February
2006 (18)

January
2006 (19)

My Links

RSS 2.0

Atom 0.3

Navigation

Blogs

A Visual Guide to Backing Up a Team Foundation Server database

Microsoft's How to: Back Up a
Team Foundation Server is a great resource, but there's so much of that
tedious reading. For the truly lazy, here's a quick visual guide to
backing up your TFS databases:

First, launch SQL Server Management Studio. Within the treeview on the left,
expand the Management node and right click on the Maintenance Plan folder.

Give the backup a good name and description, so we can remember it later.

We're going for a plain vanilla full backup.

Select the Team Foundation Server databases. If you have a dedicated SQL
Server instance, it's everything except master, model, and msdb. The full list
of tables is available in the MSDN article.

I chose to do this on demand, but you could easily set up a daily or weekly
backup schedule if you so desired.

After you complete the wizard, the new maintenance plan entry will appear as
expected. Right click it and select Execute to run it.

Here's the result of a run I did on a new TFS install; this is using the
default paths:

And there you have it. Stay tuned for my next post: restoring Team Foundation
Server databases! Same bat-time, same bat-.. er.. blog!

posted on Tuesday, May 30, 2006 10:55 AM by jatwood

Post a
Comment ::

Comments

#
Quick guide to backing up your TFS databases

Jeff Atwood at Verigo Software has posted a nice visual
guide to backing up your TFS data (based on the...

Tuesday, May 30, 2006
7:42 PM by Buck Hodges

#
VSTS Links - 06/01/2006

The Vertigo Software Team System blog has a Visual Guide
to Backing Up A Team Foundation Server Database....

Thursday, June 01,
2006 6:52 AM by Team System News

Copyright © Vertigo Software,
Inc.