How to: Restore Missing or Changed Stored Procedures

If your stored procedures are missing or have changed, you can restore them by repairing the databases for Team Foundation.

Required Permissions

To perform this procedure, you must be a member of the Administrators security group on the application-tier server for Team Foundation.

Log on to the application-tier server.
Click Start, point to Control Panel, and then click Add or Remove Programs.
Click Microsoft Visual Studio 2008 Team Foundation Server - LOC (where LOC is the three-letter locale for the installed product), and then click Change/Remove.
On the Maintenance Mode Options page, click Repair or Reinstall, and then click Next.
On the Team Foundation Server Service Account page, examine the type of account that is used for installation.
- If Use a system account is specified, click Next.
- If Specify an account is specified, click the Password box, type the password for the specified account, and then click Next.
On the Reporting Services Data Source Account page, examine the type of account that is used for installation.
- If Use Team Foundation Server service account is specified, click Next.
- If Specify an account is specified, click the Password box, type the password for the specified account, and then click Next.
On the Ready to Repair page, click Repair.

The Maintenance - Repair/Reinstall page shows installation progress.

You might be asked to specify the location of the original installation media.
On the Maintenance - Setup Complete page, click Finish.
When prompted, click Restart Now, and wait for the server to restart.

See Also