asp.net自动备份数据库

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

public void BackupDatabase(string connectionString, string backupPath)
{
    try
    {
        // 连接字符串
        string connStr = connectionString;
        // 备份路径
        string backupFilePath = Path.Combine(backupPath, "DatabaseBackup_" + DateTime.Now.ToString("yyyyMMddHHmmss") + ".bak");

        // 创建备份命令
        string backupCommand = $"BACKUP DATABASE [{connStr.Split('=')[1].Trim()}] TO DISK = N'{backupFilePath}' WITH NOFORMAT, NOINIT, NAME = N'DatabaseBackup', SKIP, NOREWIND, NOUNLOAD, STATS = 10";

        using (SqlConnection conn = new SqlConnection(connStr))
        {
            conn.Open();
            using (SqlCommand cmd = new SqlCommand(backupCommand, conn))
            {
                cmd.ExecuteNonQuery();
            }
        }

        Console.WriteLine("Database backup completed successfully.");
    }
    catch (Exception ex)
    {
        Console.WriteLine("Error during database backup: " + ex.Message);
    }
}