1

I show there was a question since 1 year ago with no answer. I have the same question now, in this new year 2020.

I need to copy an Hyperscale DB to another server in the same region/location, (the copy function is in coming soon state but not already available) someone do know how?

0

Database copy for Hyperscale is now in Public Preview as announced here on Sep 22, 2020.

If you don't like the current functionality, another option is creating a new database by restoring an existing backup.

When a copy is needed to another region use a geo-restore of the database. Create a SQL Database server in the target region if you do not already have an appropriate server there. This server should be owned by the same subscription as the original (source) server. Finally perform steps provided here.

| improve this answer | |
  • Thank you for your answer, I'm new to Azure Sql Hyperscale, is not clear for me how to manage backups. I saw there are automatically genereted bck, so I'm able to create a new DB from a point in time (10 minute ago) instant backup. I saw that backup are stored in a blob storage but i don't know how to get list of bck. Is it possible? – Cyber.Drunk Jan 11 at 21:54
  • Also there is a way to do this operation via powershell or arm template? – Cyber.Drunk Jan 11 at 21:57
  • You can use the following to see available backups – Alberto Morillo Jan 12 at 2:11
  • Get-AzureRmSqlDatabaseRestorePoints -ResourceGroupName "resname" ` -ServerName "yourservername" -DatabaseName "yourDBName" – Alberto Morillo Jan 12 at 2:11
  • # # Point in time restore database # # Get database info $Database = Get-AzureRmSqlDatabase -ResourceGroupName "rg4tips17" ` -ServerName "mssqltips17" -DatabaseName "MATH" # UTC date & time $RestorePoint = Get-Date "3/11/2017 1:50:00 AM" # Restore to point in time Restore-AzureRmSqlDatabase -FromPointInTimeBackup ` -PointInTime $RestorePoint -ResourceGroupName $Database.ResourceGroupName ` -ServerName $Database.ServerName -TargetDatabaseName "MATH-AT-10K" ` -ResourceId $Database.ResourceID -Edition "Standard" -ServiceObjectiveName "S1" – Alberto Morillo Jan 12 at 2:15

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.