none
SQL Server 2008备份突然出现问题 RRS feed

  • 问题

  • SQL Server 2008的备份Job突然出现报错,job报错信息如下:Description: Executing the query "BACKUP DATABASE [ascdb_v2_f] TO  DISK = N'D:\Progr..." failed with the following error: "A nonrecoverable I/O error occurred on file "D:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\ascdb_v2_f_backup_2012_03_14_095529_6250000.bak:" 112(failed to retrieve text for this error. Reason: 1815).  BACKUP DATABASE is terminating abnormally.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.  End Error  DTExec: The package execution returned DTSER_FAILURE (1).  Started:  9:55:27 AM  Finished: 10:16:45 AM  Elapsed:  1277.69 seconds.  The package execution failed.  The step failed.

    重建备份仍出现该提示。

    备份计划历史现实错误日下:Executing the query "BACKUP DATABASE [ascdb_v2_f] TO  DISK = N'D:\\Progr..." failed with the following error: "A nonrecoverable I/O error occurred on file "D:\\Program Files\\Microsoft SQL Server\\MSSQL\\BACKUP\\ascdb_v2_f_backup_2012_03_13_134336_4218750.bak:" 112(failed to retrieve text for this error. Reason: 1815).
    BACKUP DATABASE is terminating abnormally.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established
    。请问高手该如何解决该问题?是系统问题还是SQL Server软件问题?

    2012年3月15日 7:19

答案