SQL Server BACKUP DATABASE异常终止：查询问题，“ResultSet”属性设置不正确，参数设置不正确或连接未正确建立。 [英] SQL Server BACKUP DATABASE is terminating abnormally: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.

问题描述

问题

SQL Server 2014

SQL Server 2014

在日志文件查看器中

错误代码-1073548784

Error Code-1073548784

执行查询"BACKUP DATABASE [DBName] TO  
DISK = N'J：\\Differ ..."失败并出现以下错误："无法对数据库执行差异备份" DBName"，因为当前数据库备份不存在。通过重新发布BACKUP DATABASE执行完整数据库备份，
省略WITH DIFFERENTIAL选项。

Executing the query "BACKUP DATABASE [DBName] TO  DISK = N'J:\\Differ..." failed with the following error: "Cannot perform a differential backup for database " DBName ", because a current database backup does not exist. Perform a full database backup by reissuing BACKUP DATABASE, omitting the WITH DIFFERENTIAL option.

BACKUP DATABASE异常终止。"可能的失败原因：查询问题，"ResultSet"属性设置不正确，参数设置不正确或连接
未正确建立。

推荐答案

1）如果最近更改了SQL Server数据库恢复模型，则应手动发出新的完整备份以恢复数据库备份链。完成此操作后，将来的差异备份应该会成功运行。

1) If the SQL Server database recovery model has recently changed, you should manually issue a new full backup in order to reinstate the database backup chain. Once this is done, future differential backups should run successfully.

这篇关于SQL Server BACKUP DATABASE异常终止：查询问题，“ResultSet”属性设置不正确，参数设置不正确或连接未正确建立。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！