通过C#备份SQL Server

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

namespace SqlBackup
{
    class Program
    {
        static void Main(string[] args)
        {
            // 设置数据库连接信息
            string serverName = "localhost";
            string databaseName = "MyDatabase";
            string backupDirectory = "C:\\Backup\\";
            string userName = "username";
            string password = "password";

            // 创建一个服务器对象，用于连接到SQL Server实例
            Server server = new Server(serverName);

            // 如果需要，设置连接信息
            if (!string.IsNullOrEmpty(userName) && !string.IsNullOrEmpty(password))
            {
                server.ConnectionContext.LoginSecure = false;
                server.ConnectionContext.Login = userName;
                server.ConnectionContext.Password = password;
            }

            // 连接到数据库
            Database database = server.Databases[databaseName];

            // 创建备份设备
            BackupDeviceItem deviceItem = new BackupDeviceItem(backupDirectory, DeviceType.File);

            // 创建备份请求
            Backup backup = new Backup();
            backup.Database = databaseName;
            backup.Devices.Add(deviceItem);
            backup.Action = BackupActionType.Database;

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

            Console.WriteLine("Database backup completed successfully.");
        }
    }
}