有个库执行backup plan,job执行fail,但在error log中记录DBCC及backup都成功,备份文件也正常生成... full及log备份出现相同情况...求解..
job log:
Source: Check Database Integrity Task Executing query "USE [qc_eschedule_osm_db] ".: 50% complete End Progress Progress: 2014-08-22 08:37:48.98 Source: Check Database Integrity Task Executing query "DBCC CHECKDB(N'qc_eschedule_osm_db') WITH NO_INFO...".: 100% complete End Progress Progress: 2014-08-22 08:37:48.98 Source: Check Database Integrity Task Executing query "USE [qc_itms_db] ".: 50% complete End Progress Progress: 2014-08-22 08:37:57.04 Source: Check Database Integrity Task Executing query "DBCC CHECKDB(N'qc_itms_d... The package execution fa... The step failed.
------解决思路----------------------
超时了吧。你的库是不是很大啊?