When upgrading TFS 2015.1 to TFS 2017.2 do I leave SQL Server 2014 Always On turned on? We have TFS 2015.1 running on SQL Server 2014 with Always on and everything is working fine. Upgrading to TFS 2017.2 and assume I just leave the database server as is. Can I upgrade TFS with Always on running?
Thanks
If you leave TFS pointed at the AG, you need to make sure you have enough space for potential log file growth because the database will be left in FULL recovery mode. TFS does warn you about this during the upgrade.
If you disable the AG and point TFS at a single node, it will upgrade in Simple recovery mode, and you will need to resetup the AG after the upgrade.
Depending on how big your TFS Collection databases are and the amount of free space you have for your logs (and maybe the data files too) depends which you need.