asp.net数据库备份

using Microsoft.AspNetCore.Mvc;
using System.Data.SqlClient;

public class BackupController : Controller
{
    private readonly string _connectionString = "YourConnectionStringHere";

    public IActionResult BackupDatabase()
    {
        try
        {
            using (SqlConnection connection = new SqlConnection(_connectionString))
            {
                connection.Open();
                string backupQuery = @"
                    BACKUP DATABASE YourDatabaseName
                    TO DISK = 'C:\\Backup\\YourDatabaseName.bak'
                    WITH FORMAT, INIT, NAME = 'Full Backup of YourDatabaseName', SKIP, STATS = 10;";
                SqlCommand command = new SqlCommand(backupQuery, connection);
                command.ExecuteNonQuery();
                return Ok("Database backup completed successfully.");
            }
        }
        catch (Exception ex)
        {
            return StatusCode(500, $"Database backup failed: {ex.Message}");
        }
    }
}