SQL Server database migrations

Question

Hi All,

What is the best approach to migrate the large databases to new server with minimal/zero downtime?

If log shipping or mirroring are considered for minimal down time, which is the best one to use for migration and why?

Also would it be good to have P2V/V2V with platespin or some other tools rather than configuring shipping or mirroring to do migrations?

Thanks

David

Answer 1

The answer to all your question is "It depends" all the technology you are talking has there own use case and advantages. Platespin as a tool I do not like it is more useful for migrating standalone databases for cluster and AG the migration approach would depend on version and environmental variables.

Mirroring would have minimal downtime if you configure Sync mirroring.

---

Cheers,

Shashank

Please mark this reply as answer if it solved your issue or vote as helpful if it helped so that other forum members can benefit from it

My TechNet Wiki Articles
MVP

Answer 2

https://www.sqlshack.com/sql-server-database-migrations-with-zero-data-loss-and-zero-downtime/

---

Best Regards,Uri Dimant SQL Server MVP, http://sqlblog.com/blogs/uri_dimant/

MS SQL optimization: MS SQL Development and Optimization
MS SQL Consulting: Large scale of database and data cleansing
Remote DBA Services: Improves MS SQL Database Performance
SQL Server Integration Services: Business Intelligence