Forum Discussion
HSBHSB
Jun 18, 2021Copper Contributor
Change Azure Devops Source Control Database
We have two SQL Servers, Server A and Server B that are part of an Always On availability group. All of our Team Projects and Devops point directly to Server A. Server A is currently down. We wan...
HSBHSB
Jun 18, 2021Copper Contributor
Based on the below section from the website https://docs.microsoft.com/en-us/azure/devops/server/admin/backup/restore-data-different-instance?view=azure-devops-2020#:~:text=Restore%20data%20to%20a%20different%20server%20than%20the,new%20location%20of%20the%20content%20database.%20More%20items , all I may need to do is this.
TfsConfig registerDB /SQLInstance: ListenerAG /DatabaseName: TFS_Configuration
Can anyone confirm and is there a way to get the current value before I change this in case we need to revert for any reason?
From the link above:
To register the location of the databases:
On the application-tier server, open a Command Prompt window, and change directories to Drive:\%programfiles%\Azure DevOps Server 2019\Tools.
At the command prompt, enter the following command, where DatabaseName is the name of the configuration database (by default, TFS_Configuration):
TfsConfig registerDB /SQLInstance: ServerName /DatabaseName: DatabaseName
For more information, see RegisterDB command.
TfsConfig registerDB /SQLInstance: ListenerAG /DatabaseName: TFS_Configuration
Can anyone confirm and is there a way to get the current value before I change this in case we need to revert for any reason?
From the link above:
To register the location of the databases:
On the application-tier server, open a Command Prompt window, and change directories to Drive:\%programfiles%\Azure DevOps Server 2019\Tools.
At the command prompt, enter the following command, where DatabaseName is the name of the configuration database (by default, TFS_Configuration):
TfsConfig registerDB /SQLInstance: ServerName /DatabaseName: DatabaseName
For more information, see RegisterDB command.