October 28, 2024 at 5:47 am
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?
October 28, 2024 at 2:34 pm
I first prepared both stand alone instances.
Then I restored the needed db on one instance, configured the needed sql accounts ( using dbatools Copy-DbaUser ) and sqlagent jobs ( to be modified to act only if the "local" instance is primary ), etc
Then I created and empty db ( same name as targets ) to be able to copy sql accounts and sqlagent jobs, etc
Then I would start a new full backup followed by a log backup (disable the logbackup schedule temporary)
Restore that newly made fullbackup and log to the second node
After that I configured the AG / Listener / ... and tested the failover capability
During my tests I've performed this all full setup using Powershell scripts.
Don't forget to setup monitoring extended events on these AG db.
Are you talking about multiple databases in this AG ( but don't actually need Enterprise Edition for your applications ($$) ), consider multiple "Basic Availability groups on Std Edtn )
test it - TEST it - TEST IT and also TEST its performance !
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply