Share via

Lift and Shift SQL server database backups on Azure

Newtojob 26 Reputation points
2024-07-24T17:23:09.0933333+00:00

HI,

Can we schedule daily database backups on Azure portal for lift and shift SQL server which is in AZURE.

Thank you

Azure Backup
Azure Backup
An Azure backup service that provides built-in management at scale.
1,191 questions
Azure SQL Database
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,345 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Erland Sommarskog 107K Reputation points
    2024-07-24T21:23:34.57+00:00

    What exactly are you targeting?

    • SQL Server running on a VM in Azure?
    • SQL Server Managed Instance?
    • Azure SQL Database?

    For the first two you can do BACKUP/RESTORE. I don't think you can schedule that from the Portal (but I could be wrong), but you could schedule it from SQL Server Agent.

    For Azure SQL Database, you cannot do Backup/Restore, but you need to use Bacpacs or SQL Server Migration Assistant (SSMA). I guess you could schedule loading of Bacpacs with help some Powershell scripting. (No, I don't have any example.)

    0 comments