tag:blogger.com,1999:blog-9050180307874313601.post8461580555854903115..comments2023-10-28T11:19:52.556+01:00Comments on Matt's ALM space: A design consideration: SQL Server AlwaysOn Availability Mode for TFSMatteo Emilihttp://www.blogger.com/profile/00837137296262715946noreply@blogger.comBlogger4125tag:blogger.com,1999:blog-9050180307874313601.post-87207681894730473772018-04-19T15:17:25.339+01:002018-04-19T15:17:25.339+01:00Thanks for the reply! Apologies, I was a little un...Thanks for the reply! Apologies, I was a little unclear... I'll be using the TFSConfig RegisterDB command as "Use RegisterDB to update name of the server that hosts the configuration database" covers what we're attempting to achieve. For example, we are moving the databases from OURSERVER\SQLINSTANCE to AVAILGROUP.OURDOMAIN.COMAnonymoushttps://www.blogger.com/profile/16434882073467688271noreply@blogger.comtag:blogger.com,1999:blog-9050180307874313601.post-52008202677186545372018-04-19T13:54:07.063+01:002018-04-19T13:54:07.063+01:00No, I believe you need to use that switch on every...No, I believe you need to use that switch on every operation that affects a database which is part of an Availability Group. If you look at the docs (https://docs.microsoft.com/en-us/vsts/tfs-server/command-line/tfsconfig-cmd), every TFSConfig command has that switch.Matteo Emilihttps://www.blogger.com/profile/00837137296262715946noreply@blogger.comtag:blogger.com,1999:blog-9050180307874313601.post-62739232918118250192018-04-19T13:30:44.688+01:002018-04-19T13:30:44.688+01:00I'm currently trying to move our TFS databases...I'm currently trying to move our TFS databases to an availability group. Do I only need to run the TFSConfig command using /sqlalwayson on the tfs_configuration database alone?Anonymoushttps://www.blogger.com/profile/16434882073467688271noreply@blogger.comtag:blogger.com,1999:blog-9050180307874313601.post-27654619925131657032015-05-18T07:45:51.426+01:002015-05-18T07:45:51.426+01:00Totally agree. That's exactly the configuratio...Totally agree. That's exactly the configuration we use on our main TFS instances.Giulio Vianhttp://blog.casavian.eunoreply@blogger.com