I am planning to migrate a currently standalone database to SQL Always On. This would be an OS & SQL upgrade & migrate activity to an entire new box of servers running on latest Windows Server & SQL Server.
I have never perform this configuration before and will be referring to steps which is stated here -> https://www.sqlservercentral.com/articles/steps-for-installing-alwayson-availability-groups-sql-2019
The windows guys will be doing the clustering setup & I'll need to setup the SQL Always-On from my end. I want to confirm, once the windows cluster is ready, I will need to install standalone SQL installation on both nodes as stated on the guide then do I need to restore my databases to 1 node first before I can setup the always on?
- This topic was modified 3 hours, 2 minutes ago by JasonO.