Create a Backup of Azure SQL database to my machine using vb.net

Question

I am trying to create a backup of Azure SQL database on my machine using vb.net application.
What I have tried:

    If System.IO.Directory.Exists("c:\") = False Then System.IO.Directory.CreateDirectory("c:\")
    sql.Connect("myserver.database.windows.net", "username", "password")

    With bk
        .Database = "dbname"
        .Files = "c:\" & "\MyAzure" & Today.Date.ToString("d-M-yyyy") & ".bak"
        .SQLBackup(Sql)
    End With
    sql.DisConnect()

But I got this error:

[SQL-DMO]SQL Server myserver.database.windows.net must be upgraded to version 7.0 or later to be administered by this version of SQL-DMO.

Any help?

elfisher · Accepted Answer · 2016-06-24 18:19:22Z

1

Azure SQL Database does not support creating .bak files on-demand. Azure SQL DB automatically backups up all databases using native backups to enable you to Point-in-Time restore your database to any point in time within the databases retention period. If you would like to create a BACPAC file on-demand, you can use the Import/Export service.

answered Jun 24, 2016 at 18:19

elfisher

1,2029 silver badges14 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Create a Backup of Azure SQL database to my machine using vb.net

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related