使用c#创建SQL Server备份文件(.bak)到任何位置

using System;
using System.Data.SqlClient;

namespace SqlBackup
{
    class Program
    {
        static void Main(string[] args)
        {
            string connectionString = "Data Source=<server_name>;Initial Catalog=<database_name>;Integrated Security=True";
            string backupPath = "<backup_path>";
            string backupFileName = "<backup_file_name>.bak";

            using (SqlConnection connection = new SqlConnection(connectionString))
            {
                connection.Open();

                using (SqlCommand command = new SqlCommand())
                {
                    command.Connection = connection;
                    command.CommandText = $"BACKUP DATABASE [{connection.Database}] TO DISK='{backupPath}{backupFileName}' WITH FORMAT, MEDIANAME='Z_SQLServerBackups', NAME='Full Backup of {connection.Database}'";
                    command.ExecuteNonQuery();
                }
            }
        }
    }
}