Skip to main content
Database Administrators

Return to Question

corrected SQL Server version
Source Link
Shanky
Shanky
  • 19.1k
  • 4
  • 36
  • 58

We have two windows SQL Server 2008 R2 instances with mirroring configured. We want to upgrade them to SQL server 2014R22014.

How will this upgrade effect the mirroring between the servers, and also how should I proceed with this upgrade without causing an outage?

As per my research I can upgrade the mirrored server first to 2014 and then do a failover on 2008 server to make it mirror and the 2014 as principal and follow the same procedure to upgrade 2008 as well. Could some one please shed more light to it. What are some intrinsic points that I need to take care of?

We have two windows SQL Server 2008 R2 instances with mirroring configured. We want to upgrade them to SQL server 2014R2.

How will this upgrade effect the mirroring between the servers, and also how should I proceed with this upgrade without causing an outage?

As per my research I can upgrade the mirrored server first to 2014 and then do a failover on 2008 server to make it mirror and the 2014 as principal and follow the same procedure to upgrade 2008 as well. Could some one please shed more light to it. What are some intrinsic points that I need to take care of?

We have two SQL Server 2008 R2 instances with mirroring configured. We want to upgrade them to SQL server 2014.

How will this upgrade effect the mirroring between the servers, and also how should I proceed with this upgrade without causing an outage?

As per my research I can upgrade the mirrored server first to 2014 and then do a failover on 2008 server to make it mirror and the 2014 as principal and follow the same procedure to upgrade 2008 as well. Could some one please shed more light to it. What are some intrinsic points that I need to take care of?

added 3 characters in body; edited tags; edited title
Source Link
user1822
user1822

How to upgrade sqlSQL Server 2008 to sql serverSQL Server 2014 servers with mirroring configured

We have two windows sql serverSQL Server 2008 R2 instances with mirroring configured. We want to upgrade them to SQL server 2014R2. 

How will this up gradationupgrade effect the mirroring between the servers, and also how should I proceed with this upgrade without causing an outage.?

As per my research I can upgrade the mirrored server first to 2014 and then do a failover on 2008 server to make it mirror and the 2014 as principal and follow the same procedure to upgrade 2008 as well. Could some one please shed more light to it. What are some intrinsic points that I need to take care of?

How to upgrade sql 2008 to sql server 2014 servers with mirroring configured

We have two windows sql server 2008 R2 instances with mirroring configured. We want to upgrade them to SQL server 2014R2. How will this up gradation effect the mirroring between the servers, and also how should I proceed with this upgrade without causing an outage. As per my research I can upgrade the mirrored server first to 2014 and then do a failover on 2008 server to make it mirror and the 2014 as principal and follow the same procedure to upgrade 2008 as well. Could some one please shed more light to it. What are some intrinsic points that I need to take care of?

How to upgrade SQL Server 2008 to SQL Server 2014 servers with mirroring configured

We have two windows SQL Server 2008 R2 instances with mirroring configured. We want to upgrade them to SQL server 2014R2. 

How will this upgrade effect the mirroring between the servers, and also how should I proceed with this upgrade without causing an outage?

As per my research I can upgrade the mirrored server first to 2014 and then do a failover on 2008 server to make it mirror and the 2014 as principal and follow the same procedure to upgrade 2008 as well. Could some one please shed more light to it. What are some intrinsic points that I need to take care of?

Source Link
Raj Vikram Singh
Raj Vikram Singh
  • 31
  • 1
  • 2

How to upgrade sql 2008 to sql server 2014 servers with mirroring configured

We have two windows sql server 2008 R2 instances with mirroring configured. We want to upgrade them to SQL server 2014R2. How will this up gradation effect the mirroring between the servers, and also how should I proceed with this upgrade without causing an outage. As per my research I can upgrade the mirrored server first to 2014 and then do a failover on 2008 server to make it mirror and the 2014 as principal and follow the same procedure to upgrade 2008 as well. Could some one please shed more light to it. What are some intrinsic points that I need to take care of?