Error: OLE DB provider “SQLNCLI11” for linked server “xxxxxx” returned message “The partner transaction manager has disabled its support for remote/network transactions.”. Msg 7391, Level 16, State 2, Procedure dbo.xxxxxx, Line 1 [Batch Start Line 14] The operation could not be performed because OLE DB provider “SQLNCLI11” for linked server “xxxxxx” was unable to begin... » read more
Use Transact-SQL To manually fail over an availability group: Connect to the server instance that hosts the target secondary replica. Use the ALTER AVAILABILITY GROUP statement, as follows:ALTER AVAILABILITY GROUP group_name FAILOVER In the statement, group_name is the name of the availability group.The following example manually fails over the MyAg availability group to the connected secondary replica: Sources: https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/perform-a-planned-manual-failover-of-an-availability-group-sql-server?redirectedfrom=MSDN&view=sql-server-ver15
TestScript.cmd Result What is your name: John Specify Project?: 123 Name=John Project=123 Press any key to continue . . .
TestScript.cmd Result D:\>TestScript 1 2 First Parameter: 1 Second Parameter: 2 Press any key to continue . . .