After the secondary replica comes back online, it will not immediately be available for fail over.
You will need to wait for the 5GB of logs to send to secondary and be redone. During which time Primary will have generated more logs that will need to sync and be redone. Once all logs are synched, you'll be able to fail over to secondary without incurring ...
...when I started up the SQL Server service again on the original primary, the AG went into primary state while the secondary replica was also still in primary.
This is called "split brain" and really shouldn't happen - SQL Server and WSFC have a lot of controls built in to protect against getting into this state. What should happen is that the ...
You will select "SQL Server Stand-Alone" installation.
To create a distributed availability group, you must create two availability groups each with its own listener. You then combine these availability groups into a distributed availability group.
Once you do that on all nodes you can use these instructions to configure the Always On distributed ...
“ The installation of sql server failover cluster instance didn't go well. So I decided to remove whatever was installed and reinstall it again.”
That’s not a really good idea. It looks like whatever went wrong left behind a mess.
“ So before trying to install FCI again, do I need to perform any other uninstallations?”
Yes. First reinstall Windows.
I assume that you do not want to setup a multi-subnet clustering where each node is setup on a different subnet.
To be able to add a listener on a new subnet in the cluster the cluster computers need to be on that subnet sou you will need to add ip addresses on the new subnet to the existing network adapters on the servers (or install dedicated ones) and ...
how would I know which data file would be best to
move to the G: drive?
You could decide based on:
The latency for each database in order to balance the read/write so
that none of the two disks would be overloaded. See Monitoring
How critical is the database to choose the ones that would allow the
longer time offline for the maintenance ...