BACKUP 操作未能完成命令 BACKUP DATABASE dycw2。有关详细消息，请查看备份应用程序日志。

BACKUP DATABASE [数据库名] TO DISK = '备份文件路径' 
WITH FORMAT, MEDIANAME = '媒体库名称', MEDIADESCRIPTION = '描述信息',
NAME = '备份名称', SKIP, NOREWIND, NOUNLOAD, COMPRESSION, STATS = 10

BACKUP DATABASE [test] TO DISK = 'C:\test.bak' 
WITH FORMAT, MEDIANAME = 'test', MEDIADESCRIPTION = 'test描述',
NAME = 'test备份', SKIP, NOREWIND, NOUNLOAD, COMPRESSION, STATS = 10

无法在事务中执行备份或还原操作.BACKUP DATABASE异常终止

嗨,伙计们,我正在尝试执行backUp并restore命令在我的应用程序中建模EF6

对于我的备份我创建一个Sp,你可以在这里看到:

CREATE PROCEDURE GetBackUp
    -- Add the parameters for the stored procedure here
    @address nvarchar(max)
AS
BEGIN
    BACKUP DATABASE [db-invoice-169] to DISK=@address
END
GO

在我的应用程序中,我称之为 Sp

 private void Backup_Click(object sender, EventArgs e)
        {
            SaveFileDialog sfd = new SaveFileDialog();
            string str_filename = string.Empty;
            sfd.FileName = "backup_database_" + DateTime.Now.ToShortDateString().Replace("/", "_");
            sfd.Filter = @"backup files(*.bak)|*.bak|all files(*.*)|*.*";
            sfd.FilterIndex = 1;
            sfd.OverwritePrompt = true;
            sfd.Title = "***save backup files***";
            if (sfd.ShowDialog() == DialogResult.OK)
            {
                str_filename = sfd.FileName;
                backup(str_filename);
            }
        }
        private void backup(string str_filename)
        {
            try
            {
                this.Cursor = Cursors.WaitCursor;
                db.Database.ExecuteSqlCommand(@"EXEC [dbo].[back_up] @address = N'"+str_filename+"'");
                this.Cursor = Cursors.Default;
                MessageBox.Show("?????? ??????? ???? ?????? ???? ???");
            }
            catch (Exception ex)
            {
                MessageBox.Show("?????? ??????? ???? ?????? ???? ???? |" + ex.Message);
            }

        }

但我得到了这个错误:

Cannot perform a backup or restore operation within a transaction.  BACKUP DATABASE is terminating abnormally.