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!
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?
Do more with
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
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
Detach / Attach method
Backup & Restore method
Copy database wizard method
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
Downtime for sql server clinets will be very small. Just for switching connections to a new server
The Log Shipping idea is good. Or alternatively, the Mirroring.
But I wouldn't recommend the Replication.
But I wouldn't recommend the Replication.
Yes. Mirroring is good too and looks like it was implemented in sql server 2005, so the author can use it.
Premium Content
You need an Expert Office subscription to comment.Start Free Trial