Tfs 2010 power tools backup restore

The Windows SharePoint configuration database contains the Team Foundation Server setup and configuration information for the team project SharePoint site. The registration database contains information about Projects, Areas, Iterations, and other registration data. The Analysis Services database that contains the data for building the warehouse used by the Reporting Services. The following procedures assume that you have a working data-tier server and have a back up available.

Note If the system is deployed on dual servers, make sure that you are logged on to the appropriate server for each step. All data related steps must be done on the server where the data resides. All services related steps, such as starting and stopping IIS, must be performed on the application-tier server.

The Reporting Services are included on the application tier. For single server deployments, both tiers are on one computer and you do not have to log on separately for each tier. Caution You must restore all databases to the same instant in time or the databases become corrupted.

The first backup you apply must be a full backup, followed by the transaction log backups, in the order they were created. After restoring the databases, you have to build the data warehouse. The data warehouse is a data cube populated by the Analysis Services from the underlying TfsWarehouse database. The data warehouse serves the Reporting Services.

Note If you have additional data backed up that must be restored, follow the steps appropriate for restoring that data. After the data is restored, you can restart the services unless you are restoring to a different server than the original.

Warning Do not restart the servers now if you are restoring data to a different server. You must perform additional steps before restarting the data server.

After restoring the data, the cache must be refreshed to use the restored data. By using the Web services on the application tier, you can force clients to re-initialize the work item tracking cache the next time that the clients connect. Comments are closed. Jay Gordon Cloud Advocate. Gloridel Morales Senior Program Manager. Zachary Deptawa Cloud Advocate. Steven Murawski Principal Cloud Advocate. Martina Director of Product Management. Learn more about Azure DevOps.

Azure DevOps Feature Timeline. DevOps at Microsoft. Improve this answer. I should have mentioned that I had previously stumbled onto that article.

I would amend "delicate" with "painful. Funny, I originally wrote 'painful', then rewrote to 'delicate' :.

I'm not aware of existing shared scripts that can do this. Maybe someone has it in their private collection If you build one, please do share : — jessehouwing. Radwan -MVP Mohamed. Radwan -MVP 2, 2 2 gold badges 14 14 silver badges 22 22 bronze badges. Sign up or log in Sign up using Google. Sign up using Facebook. This tool only supports one backup schedule per TFS server.

Clicking Configure will make all of the changes necessary to configure your TFS server for backup. Click Next again and you are done! Your server is fully configured for backups compare that to the docs :. Once a backup plan has been configured, the panel for Team Foundation Backups will look more like this. It will show you many of your settings and provide a set of administrative actions on the right. If you click Take Full Backup Now, it will perform a back up and put it in the file system location specified in the plan.

Restoring a backup is a bit trickier and it depends on exactly what you are trying to do. There are two basic scenarios that we enable:. Please take these steps only as demonstrative and look at the docs that come with the Power Tools to get a more thorough understanding of what you need to do based on your configuration.

This will shutdown all of the TFS services and release any database locks. If you are only restoring individual collections, the tool will prompt you to take any collections you are restoring offline and will automatically copy the replaced collection aside. This tool is conservative.

So, except in the case of restoring individual collections, if you plan to restore a backup of a database that already exists, you must first delete the database. How quickly will I get my solution? We can't guarantee quick solutions - Experts Exchange isn't a help desk.

We're a community of IT professionals committed to sharing knowledge. Our experts volunteer their time to help other people in the technology industry learn and succeed. Plans and Pricing. Contact Us. Certified Expert Program. Credly Partnership.