• Status: Solved
  • Priority: High
  • Security: Public
  • Views: 60
  • Last Modified:

Migration from SQL Server 2008 R2 FCI to SQL Server 2016 Always ON FCI.

Please provide detailed solutions for following two scenarios exclude BI Components.

1. In place Up gradation from SQL Server 2008 R2 FCI to SQL Server 2016 AlwaysOn FCI.(Two Node : Active/Passive)

2. Migration from SQL Server 2008 R2 FCI to SQL Server 2016 AlwaysOn FCI ( Two node : Active / Passive)

Thanks,
Chandra
0
Chandra Mohan Kanithi
Asked:
Chandra Mohan Kanithi
  • 2
1 Solution
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
To use AlwaysOn feature you'll need an Active / Active Windows cluster.
Even AlwaysOn works with SQL Server clustered instances, I will recommend you to do not go for that path. Instead, install a SQL Server stand-alone instance in each of the Windows Cluster nodes. This will guarantee that you won't have a single point of failure as you would if you go for a clustered instances (failure point will be storage).
1
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
Question answered.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now