July 14, 2017 at 7:12 pm
Hi,
i need to setup the always on my databases .i need to design the infrastructure .can any one suggest server type and what are required .
July 16, 2017 at 3:35 pm
first...Always On doesn't mean anything. Do you mean Failover Cluster Instances, or Availability Groups?
Second, you need to go check the Microsoft documentation on this, for whichever of the two you mean.
Both require a Windows cluster. FCI requires shared storage, AGs do not. LOTS of other differences far beyond the scope of a mere forum post...
------------------------------------------------------------------------------------------------Standing in the gap between Consultant and ContractorKevin3NFDallasDBAs.com/BlogWhy is my SQL Log File HUGE?!?![/url]The future of the DBA role...[/url]SQL Security Model in Plain English[/url]
July 17, 2017 at 3:05 am
Check out Perry's Stairway.
July 18, 2017 at 2:02 am
Hi Sree,
You may also check out the link below on "Prereqs, Restrictions, Recommendations - Always On Availability Groups"
July 19, 2017 at 5:21 am
Sree Divya - Friday, July 14, 2017 7:12 PMHi,i need to setup the always on my databases .i need to design the infrastructure .can any one suggest server type and what are required .
Start here
http://www.sqlservercentral.com/stairway/112556/
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply