在您的团队基础服务器上就地升级 sql server

本文介绍了在您的团队基础服务器上就地升级 sql server的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

在团队基础服务器 2015 实例运行和使用 SQL Server 版本时，是否可以对其进行就地升级(例如将 2012 Express 升级到标准版)?这需要额外的配置还是我们需要先分离/附加团队项目集合?

Is it possible to do an in place upgrade of you SQL server edition, (for example upgrade 2012 Express to Standard), when it is running and used by a team foundation server 2015 instance? Will this need extra configuration or will we need to detach/attach the team project collections first?

我找不到有关如何执行此操作的任何信息.只说明了如何升级teamfoundation server本身，或者说sql server的版本升级没有问题，不说明两者结合.

I can't find any information about how to do this. It is only stated how to upgrade the team foundation server itself, or that it is no problem to do edition upgrades of sql server, but not the combination of the two.

推荐答案

是

您可以:

使用 TFSServiceControl quiesce 命令关闭服务器服务.

按照 SQL Server 说明就地升级 SQL Server

使用 TFSServiceControl unquiesce 命令打开您的服务器服务.

Use the TFSServiceControl quiesce command to turn off your servers services.

Upgrade SQL Server in place following SQL Servers Instructions

Use the TFSServiceControl unquiesce command to turn on your servers services.

www.visualstudio/en-us/docs/setup-admin/tfs/command-line/tfsservicecontrol-cmd