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