debasishbhat | SQLServerCentral

debasishbhat

Forum Replies Created

Viewing 4 posts - 1 through 5 (of 5 total)

RE: SQL AG Upgrade

You can refer below link for AG upgrade.But I think failback from Hogher version to lower version will not be possible.
https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/upgrading-always-on-availability-group-replica-instances?view=sql-server-2017

January 16, 2019 at 3:55 am

#2019045
RE: Cannot bring the Windows Server Failover Clustering (WSFC) resource (ID '38e4748b-1b06-4017-9c3a-e7eb3f45cb2c') online (Error code 5018).

databases.specialist - Monday, January 14, 2019 6:30 PM
select * from sys.availability_groups;
giving zero rows selected.
group_id name resource_id resource_group_id failure_condition_level health_check_timeout automated_backup_preference automated_backup_preference_desc version basic_features dtc_support db_failover is_distributed
drop availability giving as it does not exist..
DROP...

January 16, 2019 at 2:43 am

#2019043
RE: Error in add listener

Please check weather Listener entry exists in DNS or service account have permission to create it in AD

January 16, 2019 at 1:32 am

#2019037
RE: Cannot bring the Windows Server Failover Clustering (WSFC) resource (ID '38e4748b-1b06-4017-9c3a-e7eb3f45cb2c') online (Error code 5018).

From your log I can find below error
000025c8.0000096c::2019/01/14-06:15:58.490 ERR [RES] SQL Server Availability Group <OST-MOD-DBS-AG1>: [hadrag] Did not find the instance to connect in SqlInstToNodeMap key.
SqlInstToNodeMap...

January 14, 2019 at 2:06 am

#2018805

Viewing 4 posts - 1 through 5 (of 5 total)