index > Team Foundation Server - Administration > SQL Maintenance on TFS

SQL Maintenance on TFS

Hello,

I just finished installing the TFS and set up the maintenance plan for a regular backup. However, I see that there are plenty of other maintenance tasks that can be done on the SQL side of the server. Should any of those performed on a regular basis? Things like "Check Database Integrity" and "Reorganize/Rebuild Index" seem to be important things to be done on the DB in order to keep it running optimally. Please let me know. Thanks!

Bobby Chan

Hi Bobby,

You might find some good advice here: http://msdn2.microsoft.com/en-us/library/ms253070.aspx

This is the page that contains the guide for setting up a maintenance plan, and it also contains some good links on general SQL topics.

-Matt

http://blogs.msdn.com/tfs_migration/

Matthew Mitrik MSFT

reply 2

You can use google to search for other answers

More Articles

·Team Foundation Workgroup and Sharepoint

·TF53011 Error. Can't change account on client side for TFS login

·Creating / Modifying Alerts

·Migrate Team Foundation Server from Server to Server?

·Answering some user questions about TFS failures

·Change SQL Connection String.

·Security behaving strange when adding users to project groups

·Where i can see about what TFS Version installed?

·Cannot connect to TFS

·Check if the App Pool account is a member of ServiceAccounts grou...

Welcome to Bokebb New Update Joins the collection

New Articles

·How to update the name of a team project
·about project alert
·Service Account
·How do I keep TFS services up all the ti��
·Complications with installing TFS on unt��
·TExporer: The operation has timed out
·Failed to create team project
·Some users can not publish test result: ��
·Problems when uploading a process templa��
·Project Portals stop working after resto��
·proxy bypassed?????
·Cannot insert duplicate key in object 'd��
·Where is the reference about CommonStruc��
·Numerous errors in the Application Event��
·VPN Access failing

Hot Articles

·disk space
·Create New project using macro
·Move TFS projects
·Security behaving strange when adding us��
·MS Project file in Sharepoint marked as ��
·Subscription problem
·User account deleted and recreated: SID ��
·Project Security Defect?
·TF53010: An unexpected condition has occ��
·Sharepoint project lost
·Identify who has code checked out
·Restore Team Foundation Server from a do��
·Setting up Web Site on Different Server
·TF31001 and TF31002 Errors on TFS
·Removing Project Alerts

Recommend Articles

·I can not customize sharepoint portal fo��
·Could not resolve the user or group.
·Restore-move but re-create Sharepoint
·add a default permission to an area
·Security - still don't get it...
·TF53011 But not after een upgrade to wor��
·how to replace a project while retaining��
·TFS Project Structure creation
·Windows Groups - TFS does not see new us��
·TF30177: Team Project Creation Failed (t��
·Change of Team Explorer User
·Problem with workgroup edition installed��
·Change SQL Connection String.
·permissions to users in VSTS
·Failed to create team project