我收到错误“服务器'备份失败'XYZ-PC \\ SQLEXPRESS'如何解决它 [英] i got the error "backup failed for Server 'XYZ-PC\\SQLEXPRESS'.how to resolve it

问题描述

 public void button1_Click（object sender，EventArgs e）
 {
 try 
 {
 
 //定义备份对象变量。 
备份sqlBackup = new Backup（）; 
 
 //指定备份类型，描述，名称和要备份的数据库。 
 sqlBackup.Action = BackupActionType.Database; 
 sqlBackup.BackupSetDescription =BackUp of：+Garment.mdf+on+ DateTime.Now.ToShortDateString（）; 
 sqlBackup.BackupSetName =FullBackUp; 
 sqlBackup.Database =Garment.mdf; 
 
 //声明BackupDeviceItem 
 BackupDeviceItem deviceItem = new BackupDeviceItem（D：\\SQLBackup+Garment.bak，DeviceType.File）; 
 //定义服务器连接
 ServerConnection connection = new ServerConnection（。\\SQLEXPRESS）; 
 //避免TimeOut异常
服务器sqlServer = new服务器（连接）; 
 sqlServer.ConnectionContext.StatementTimeout = 60 * 60; 
数据库db = sqlServer.Databases [Garment.mdf]; 
 
 sqlBackup.Initialize = true; 
 sqlBackup.Checksum = true; 
 sqlBackup.ContinueAfterError = true; 
 
 //将设备添加到备份对象。 
 sqlBackup.Devices.Add（deviceItem）; 
 //将Incremental属性设置为False以指定这是完整数据库备份。 
 sqlBackup.Incremental = false; 
 
 sqlBackup.ExpirationDate = DateTime.Now.AddDays（3）; 
 //指定备份完成后必须截断日志。 
 sqlBackup.LogTruncation = BackupTruncateLogType.Truncate; 
 
 sqlBackup.FormatMedia = false; 
 //运行SqlBackup以在SQL Server实例上执行完整数据库备份。 
 sqlBackup.SqlBackup（sqlServer）; 
 //从备份对象中删除备份设备。 
 sqlBackup.Devices.Remove（deviceItem）; 
 
} 
 catch（exception ex）
 {
 MessageBox.Show（ex.Message，Error，MessageBoxButtons.OK，MessageBoxIcon.Error）; 
} 
} 
} 
} 

解决方案

有很多可能的原因：请参阅此处：使用C＃备份SQL数据库 [ ^ ]

 public void button1_Click(object sender, EventArgs e)
        {
            try
            {

                //Define a Backup object variable.
                Backup sqlBackup = new Backup();

                //Specify the type of backup, the description, the name, and the database to be backed up.
                sqlBackup.Action = BackupActionType.Database;
                sqlBackup.BackupSetDescription = "BackUp of:" + "Garment.mdf" + "on" + DateTime.Now.ToShortDateString();
                sqlBackup.BackupSetName = "FullBackUp";
                sqlBackup.Database = "Garment.mdf";

                //Declare a BackupDeviceItem
                BackupDeviceItem deviceItem = new BackupDeviceItem("D:\\SQLBackup" + "Garment.bak", DeviceType.File);
                //Define Server connection
                ServerConnection connection = new ServerConnection(".\\SQLEXPRESS");
                //To Avoid TimeOut Exception
                Server sqlServer = new Server(connection);
                sqlServer.ConnectionContext.StatementTimeout = 60 * 60;
                Database db = sqlServer.Databases["Garment.mdf"];

                sqlBackup.Initialize = true;
                sqlBackup.Checksum = true;
                sqlBackup.ContinueAfterError = true;

                //Add the device to the Backup object.
                sqlBackup.Devices.Add(deviceItem);
                //Set the Incremental property to False to specify that this is a full database backup.
                sqlBackup.Incremental = false;

                sqlBackup.ExpirationDate = DateTime.Now.AddDays(3);
                //Specify that the log must be truncated after the backup is complete.
                sqlBackup.LogTruncation = BackupTruncateLogType.Truncate;

                sqlBackup.FormatMedia = false;
                //Run SqlBackup to perform the full database backup on the instance of SQL Server.
                sqlBackup.SqlBackup(sqlServer);
                //Remove the backup device from the Backup object.
                sqlBackup.Devices.Remove(deviceItem);

            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
        }
    }
}

解决方案

There are loads of possible reasons: See here: Backing up an SQL Database in C#[^]

这篇关于我收到错误“服务器'备份失败'XYZ-PC \\ SQLEXPRESS'如何解决它的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！