使用C#备份托管在服务器上的SQL Server数据库时出现问题

USE master;
GRANT BACKUP DATABASE TO [YourUser];

string backupPath = @"\\Server\Backup\YourDatabase.bak";
if (Directory.Exists(backupPath))
{
    long freeSpace = new DriveInfo(new FileInfo(backupPath).DirectoryName).AvailableFreeSpace;
    if (freeSpace < expectedBackupSize)
    {
        throw new Exception("Not enough disk space for backup.");
    }
}

string localBackupPath = @"C:\LocalBackup\YourDatabase.bak";
string remoteBackupPath = @"\\Server\Backup\YourDatabase.bak";

// Perform backup to local path first
BackupDatabase(localBackupPath);

// Then copy to remote path
File.Copy(localBackupPath, remoteBackupPath, true);

ServiceController sqlServerService = new ServiceController("MSSQLSERVER");
if (sqlServerService.Status != ServiceControllerStatus.Running)
{
    sqlServerService.Start();
}

using System.Data.SqlClient;

public void BackupDatabase(string backupPath)
{
    string connectionString = "Server=YourServer;Database=YourDatabase;User Id=YourUser;Password=YourPassword;";
    string backupQuery = $"BACKUP DATABASE [YourDatabase] TO DISK = N'{backupPath}' WITH NOFORMAT, NOINIT, NAME = N'YourDatabase-Full Database Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10";

    using (SqlConnection connection = new SqlConnection(connectionString))
    {
        SqlCommand command = new SqlCommand(backupQuery, connection);
        connection.Open();
        command.ExecuteNonQuery();
    }
}