mssql数据库备份代码

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

class Program
{
    static void Main()
    {
        // 连接到SQL Server实例
        Server server = new Server("your_server_name");

        // 指定数据库名称
        Database db = server.Databases["your_database_name"];

        // 创建备份设备
        BackupDeviceItem device = new BackupDeviceItem("C:\\Backup\\your_database_name.bak", DeviceType.File);

        // 创建备份对象
        Backup backup = new Backup();
        backup.Action = BackupActionType.Database;
        backup.Database = db.Name;
        backup.Devices.Add(device);
        backup.BackupSetName = "Full Backup of " + db.Name;
        backup.BackupSetDescription = "Full Backup";
        backup.Initialize = true;
        backup.Checksum = true;

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

        Console.WriteLine("Backup completed successfully.");
    }
}