Share via

Azure SQL Managed Instance : DB To Clone

Rohit Kulkarni 731 Reputation points
2022-02-04T11:42:20.18+00:00

Hello Team,

I have Azure SQL Managed Instance :(XY) under that there is called DB1 database present. Whether I can clone this database(DB1) to (DB2) in the same Azure SQL Managed Instance :(XY).If you have any documentation or link Please feel to share .

Thanks in advance

Regards
RK

Azure SQL Database
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. GeethaThatipatri-MSFT 29,597 Reputation points Microsoft Employee Moderator
    2022-02-04T14:35:58.89+00:00

    Hi, @Rohit Kulkarni Thanks for posting your query in Microsoft foram,
    Thanks, @Alberto Morillo for your contribution and for providing the documentation.

    Adding to AlbertoMorillo the easy way I would say will be to execute a restore point in time to a new name using the portal, or you can backup and restore,by using this you can save the "backup" time. Here is the link for your reference
    You can't overwrite the DB but you can create a new one.

    Regards
    Geetha

    Was this answer helpful?

  2. Alberto Morillo 35,506 Reputation points MVP Volunteer Moderator
    2022-02-04T12:31:18.093+00:00

    Hi Rohit

    You can use geo-restore to restore a backup from the first Managed Instance to the Second Managed Instance. as explained here.

    Hope this helps

    Was this answer helpful?

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.