Link to home
Start Free TrialLog in
Avatar of Tom Patterson
Tom PattersonFlag for United States of America

asked on

Migrate SQL 2008 r2 to a new Windows 2012 cluster

What is the best way to migrate a SQL 2008 R2 instance that is hosted on a Windows 2008 R2 Failover cluster to a newer cluster running Windows 2012?  Oh, yeah, with as little downtime as possible?
ASKER CERTIFIED SOLUTION
Avatar of Vitor Montalvão
Vitor Montalvão
Flag of Switzerland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Yes. Mirroring is good too and looks like it was implemented in sql server 2005, so the author can use it.
Avatar of Tom Patterson

ASKER

Since this is going from one Windows Server Failover Cluster to another.  What do you think of using the Copy Cluster Roles feature?
Copy Cluster Roles has nothing to do with SQL Server databases.
Recommendation to close this question by accepting the above comments as solution.