在c#中创建SQL Server备份

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

public void CreateBackup(string serverName, string databaseName, string backupPath)
{
    // 创建服务器连接
    ServerConnection serverConnection = new ServerConnection(serverName);

    // 创建服务器对象
    Server server = new Server(serverConnection);

    // 创建数据库对象
    Database database = server.Databases[databaseName];

    // 创建备份设备对象
    BackupDeviceItem backupDevice = new BackupDeviceItem(backupPath, DeviceType.File);

    // 创建备份对象
    Backup backup = new Backup();
    backup.Action = BackupActionType.Database;
    backup.Database = databaseName;
    backup.Devices.Add(backupDevice);

    // 执行备份操作
    backup.SqlBackup(server);
}