winform数据库备份

using System;
using System.Data.SqlClient;
using System.IO;

public void BackupDatabase(string connectionString, string backupPath)
{
    try
    {
        // 获取数据库名称
        SqlConnectionStringBuilder builder = new SqlConnectionStringBuilder(connectionString);
        string databaseName = builder.InitialCatalog;

        // 创建备份命令
        string backupCommand = $"BACKUP DATABASE [{databaseName}] TO DISK = N'{backupPath}' WITH FORMAT, INIT, NAME = N'{databaseName}-Full Database Backup', SKIP, STATS = 10";

        // 执行备份命令
        using (SqlConnection connection = new SqlConnection(connectionString))
        {
            connection.Open();
            using (SqlCommand command = new SqlCommand(backupCommand, connection))
            {
                command.ExecuteNonQuery();
            }
        }

        MessageBox.Show("数据库备份成功！");
    }
    catch (Exception ex)
    {
        MessageBox.Show($"数据库备份失败：{ex.Message}");
    }
}