积极答复者
SQL Server 2008的备份Job突然出现报错

问题
-
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软件问题?
答案
-
D盘空间够么?
sql server job 运行账户有这个磁盘的访问权限么?
family as water
- 已建议为答案 Molly Chen_Moderator 2012年3月22日 1:48
- 已标记为答案 Molly Chen_Moderator 2012年3月23日 2:42
全部回复
-
D盘空间够么?
sql server job 运行账户有这个磁盘的访问权限么?
family as water
- 已建议为答案 Molly Chen_Moderator 2012年3月22日 1:48
- 已标记为答案 Molly Chen_Moderator 2012年3月23日 2:42