From the course: Microsoft Azure Database Administrator Associate (DP-300) Cert Prep by Microsoft Press

Unlock this course with a free trial

Join today to access over 25,300 courses taught by industry experts.

Implement Azure SQL Managed Instance database copy and move

Implement Azure SQL Managed Instance database copy and move

From the course: Microsoft Azure Database Administrator Associate (DP-300) Cert Prep by Microsoft Press

Start my 1-month free trial Buy for my team

Implement Azure SQL Managed Instance database copy and move

“

- Welcome back. This is lesson 3.10, Implement Azure SQL Managed Instance Database Copy and Move. So in this video, we're going to focus solely on Azure SQL managed instance, specifically how to copy or move a database from one managed instance to another managed instance. When you copy or move a database between managed instances, SQL server does this through using always on availability group technology. It simply creates a new database on the destination instance as a copy of the source database. When doing a copy, the source database remains online during the operation, but a move operation drops the source database once the move operation is complete. You can run multiple database copies or move operations from the source-managed instance to one or more target instances. But I do want to be clear that this is different from than a point in time restore. A point in time restore creates a copy of the source database from a specific moment in the past, whereas the copy move…

Contents