将SQL Server Service Pack升级到SP2 - TFS 2017 [英] Upgrading SQL server service pack to SP2 - TFS 2017

问题描述

计划将SQL Server 2014上的Service Pack升级到SP2，以用于我们的TFS 2017实例。  任何人都知道这应该是顺利更新还是我应该遵循某些步骤？

谢谢

解决方案

您好rafaelromerooxy，

您需要在升级SQL服务器之前停止TFS服务。

按照以下步骤升级SQL Server实例：

1。使用 TFSServiceControl quiesce 命令关闭服务器服务。

• 2。按照SQL Server说明升级SQL Server
• 3。使用 TFSServiceControl unquiesce 命令打开服务器服务。
  
• TFSServiceControl命令的文档：
• https://www.visualstudio.com/en-us/docs/setup-admin/tfs/command-line / tfsservicecontrol-cmd

最好的问候

Planning on upgrading the service pack on SQL server 2014  to SP2 for our TFS 2017 instance.  Anyone know if this should be a smooth update or should I follow certain steps?

Thanks

解决方案

Hi rafaelromerooxy,

You need to stop TFS services before upgrade SQL server.

Follow next steps to upgrade your SQL server instance:

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

• 2. Upgrade SQL Server in place following SQL Servers Instructions
• 3. Use the TFSServiceControl unquiesce command to turn on your servers services.
• There is the document for TFSServiceControl Command:
• https://www.visualstudio.com/en-us/docs/setup-admin/tfs/command-line/tfsservicecontrol-cmd

Best Regards

这篇关于将SQL Server Service Pack升级到SP2 - TFS 2017的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！