Migrate SQL 2008 r2 to a new Windows 2012 cluster

Tom Patterson
Tom Patterson used Ask the Experts™
on
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?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
IT Engineer
Distinguished Expert 2017
Commented:
Tom, please give a read in these 3 articles that I wrote for SQL Server database migration. After that you should be able to suit yourself but feel free to return to me with more questions:
Detach / Attach method
Backup & Restore method
Copy database wizard method
Alexander ArdatovSoftware Manager
Commented:
Like an idea: you can setup a new Sql Server on a newer cluster running Windows 2012, setup a replication (or log shipping) for DBs on old server to a new one and when the replication completes switch connections to a new server.
Downtime for sql server clinets will be very small. Just for switching connections to a new server
Vitor MontalvãoIT Engineer
Distinguished Expert 2017
Commented:
The Log Shipping idea is good. Or alternatively, the Mirroring.
But I wouldn't recommend the Replication.
Ensure you’re charging the right price for your IT

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

Alexander ArdatovSoftware Manager

Commented:
Yes. Mirroring is good too and looks like it was implemented in sql server 2005, so the author can use it.

Author

Commented:
Since this is going from one Windows Server Failover Cluster to another.  What do you think of using the Copy Cluster Roles feature?
Vitor MontalvãoIT Engineer
Distinguished Expert 2017

Commented:
Copy Cluster Roles has nothing to do with SQL Server databases.
Vitor MontalvãoIT Engineer
Distinguished Expert 2017

Commented:
Recommendation to close this question by accepting the above comments as solution.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial