使用 smo 以编程方式备份​​和还原 Azure 数据库

我们有一个正在运行的网络应用程序。一切都托管在 azure 上。 我们有一台sql server和两个数据库：生产和测试。 客户请求备份生产数据库并将其恢复以代替测试数据库的功能。我正在使用以下代码：

    public static void BackupDatabase(string databaseName, string userName, string password, string serverName, string destinationPath)
    {
        try
        {
            Backup sqlBackup = new Backup();

            sqlBackup.Action = BackupActionType.Database;
            sqlBackup.BackupSetDescription = "ArchiveDataBase:" + DateTime.Now.ToShortDateString();
            sqlBackup.BackupSetName = "Archive";

            sqlBackup.Database = databaseName;

            BackupDeviceItem deviceItem = new BackupDeviceItem(destinationPath, DeviceType.File);
            ServerConnection connection = new ServerConnection(serverName, userName, password);
            Server sqlServer = new Server(connection);

            Database db = sqlServer.Databases[databaseName];

            sqlBackup.Initialize = true;
            sqlBackup.Checksum = true;
            sqlBackup.ContinueAfterError = true;

            sqlBackup.Devices.Add(deviceItem);
            sqlBackup.Incremental = false;

            sqlBackup.ExpirationDate = DateTime.Now.AddDays(3);
            sqlBackup.LogTruncation = BackupTruncateLogType.Truncate;

            sqlBackup.FormatMedia = false;

            sqlBackup.SqlBackup(sqlServer);
        }
        catch (FailedOperationException ex)
        {
            throw;
        }
        catch(ConnectionFailureException ex)
        {
            throw;
        }
        catch (Exception ex)
        {
            throw;
        }
    }

    public static void RestoreDatabase(string databaseName, string filePath, string serverName, string userName, string password, string dataFilePath, string logFilePath)
    {
        try
        {
            Restore sqlRestore = new Restore();

            BackupDeviceItem deviceItem = new BackupDeviceItem(filePath, DeviceType.File);
            sqlRestore.Devices.Add(deviceItem);
            sqlRestore.Database = databaseName;

            ServerConnection connection = new ServerConnection(serverName, userName, password);
            Server sqlServer = new Server(connection);

            Database db = sqlServer.Databases[databaseName];

            db.Drop();

            sqlRestore.Action = RestoreActionType.Database;
            string dataFileLocation = dataFilePath + databaseName + ".mdf";
            string logFileLocation = logFilePath + databaseName + "_Log.ldf";
            db = sqlServer.Databases[databaseName];
            RelocateFile rf = new RelocateFile(databaseName, dataFileLocation);

            System.Data.DataTable logicalRestoreFiles = sqlRestore.ReadFileList(sqlServer);
            sqlRestore.RelocateFiles.Add(new RelocateFile(logicalRestoreFiles.Rows[0][0].ToString(), dataFileLocation));
            sqlRestore.RelocateFiles.Add(new RelocateFile(logicalRestoreFiles.Rows[1][0].ToString(), logFileLocation));

            sqlRestore.SqlRestore(sqlServer);
            db = sqlServer.Databases[databaseName];
            db.SetOnline();
            sqlServer.Refresh();
        }
        catch(ExecutionFailureException ex)
        {
            throw;
        }
    }

一切都在本地和所有虚拟机上运行。但现在我们在 Azure 上拥有了所有内容，我不知道应该设置什么备份目录。它必须是 sqlclient（可能是 azure sql 客户端）可以访问的服务器上的目录。在将数据库恢复到测试数据库期间提供位置时，情况也是如此。

如何访问可以存储备份以及可以保存 mdf 和日志文件的目录？

亲切的问候