asp.net定时备份数据库

Install-Package Quartz

using System;
using System.Data.SqlClient;
using Quartz;

public class DatabaseBackupJob : IJob
{
    public void Execute(IJobExecutionContext context)
    {
        string connectionString = "your_connection_string";
        string backupPath = @"C:\Backup\your_database_backup.bak";

        using (SqlConnection connection = new SqlConnection(connectionString))
        {
            connection.Open();
            string query = $"BACKUP DATABASE [your_database] TO DISK = '{backupPath}' WITH FORMAT, INIT, NAME = 'Full Backup of your_database', SKIP, STATS = 10";
            using (SqlCommand command = new SqlCommand(query, connection))
            {
                command.ExecuteNonQuery();
            }
        }
    }
}

using Quartz;
using Quartz.Impl;
using System;

public class QuartzScheduler
{
    public static void Start()
    {
        IScheduler scheduler = StdSchedulerFactory.GetDefaultScheduler();
        scheduler.Start();

        IJobDetail job = JobBuilder.Create<DatabaseBackupJob>()
            .WithIdentity("databaseBackupJob", "group1")
            .Build();

        ITrigger trigger = TriggerBuilder.Create()
            .WithIdentity("databaseBackupTrigger", "group1")
            .StartNow()
            .WithCronSchedule("0 0 2 * * ?") // 每天凌晨2点执行
            .Build();

        scheduler.ScheduleJob(job, trigger);
    }
}

protected void Application_Start(object sender, EventArgs e)
{
    QuartzScheduler.Start();
}