SQL Server SMO从远程服务器本地备份

using System;
using System.IO;
using Microsoft.SqlServer.Management.Common;
using Microsoft.SqlServer.Management.Smo;

namespace SMOBackup
{
    class Program
    {
        static void Main(string[] args)
        {
            // 设置远程服务器连接信息
            string serverName = "RemoteServerName";
            string databaseName = "DatabaseName";
            string userName = "Username";
            string password = "Password";

            // 创建SMO服务器对象
            ServerConnection conn = new ServerConnection();
            conn.ServerInstance = serverName;
            conn.LoginSecure = false;
            conn.Login = userName;
            conn.Password = password;
            Server server = new Server(conn);

            // 获取要备份的数据库对象
            Database db = server.Databases[databaseName];

            // 创建备份文件
            Backup backup = new Backup();
            backup.Action = BackupActionType.Database;
            backup.Database = db.Name;
            backup.Devices.AddDevice(@"C:\Backup\DatabaseBackup.bak", DeviceType.File);
            backup.SqlBackup(server);

            // 关闭连接
            conn.Disconnect();
        }
    }
}