November 27, 2019 at 4:14 am
Hello,
We have currently SQL Server 2016 (SP2-CU6) (X64) Standard Edition (64-bit) on Windows Server 2016 Standard 10.0 <X64> (Hypervisor) and we are planning to create another sql server so we can setup ALWAYS ON.
Could you please guide me what's the requirements should consider for Windows server configuration (existing and new, Sql Server installation and Set up for Always ON?
Windows Server Failover Clustering need to be installed and setup before SQL is installed or SQL Always-On setup?
What's the best way i can configure and set up Always ON?
Thank You so much for your help!
November 27, 2019 at 11:56 am
'Always on' is a term Microsoft use for a few different availability solutions. Have you decided which one you will use? There are some details on the differences here https://docs.microsoft.com/en-us/sql/database-engine/sql-server-business-continuity-dr?view=sql-server-ver15
The link is for 2017 so there are a few differences but, as far as I know, the fundamental options are the same.
If you have any questions on the article I linked then please ask and someone will try to help.
It might also help if you can advise the reasons for setting up the second instance? Is it only in case the existing instance fails or do you want some queries running against the second instance when the first instance is working? Also do you have more than one database on the existing instance?
November 28, 2019 at 3:23 am
Thank you!
We are just setting up 2nd server for DR purpose so existing instance fails then we can use other one.
We don't have more DBs, only two DB
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply