Home Forums Cloud Computing SQL Azure - Administration How to continue our SQL agent scheduled daily backup in Azure? RE: How to continue our SQL agent scheduled daily backup in Azure?

  • October 25, 2017 at 2:42 am

    #1965064

    qur7 - Tuesday, October 24, 2017 8:14 AM

    Hi,
    So let me take a crack at answering this. Please be mindful that I am no way azure expert here but have worked on it. In Azure, there is two type of databases; Azure DB as a service and Azure VM. Since you have not mentioned which type I will answer both for you.

    If you are referring to SQL DB as a service, as mentioned earlier, as soon as DB is created the Backup schedule will kick in automatically by Azure: I believe the schedule has already been mentioned one of the posts above.

    For Azure SQL Server VM, you setup your backup backups just like in a on-premises SQL server with scedule jobs or maintinance plans.

    Hope it helps.

    B

    We are using Azure DB.
    Today, I got errors when I tried to import (Import Data-tier Application) a BACPAC file generated from my Azure DB to my UAT server (SQL Server 2014, sp2), it says:

    "Could not import package.

    Waring SQL0: A project which specifiesMicrosoft Azure SQL Database v12 as the target platform may experiencecompatibility issue with SQL Server 2014."

    Microsoft says it is an known issue but I don't know how to fix the problem.
    https://social.technet.microsoft.com/Forums/WINDOWS/en-US/5b37d868-3106-4358-b7a6-a50d0890f079/sql-azure-import-of-bacpac-does-not-work-after-upgrade-to-v12?forum=ssdsgetstarted

    Any idea?