本人是新手 现在在sqlserver中的job activity monitor发现一个错误
我右击查看了它的view history 出现如下错误:
然后点开其中一个 有下面这些结果:
Executed as user: YUANLIU\prj-bi. ...ion 10.50.2500.0 for 64-bit Copyright (C) Microsoft Corporation 2010. All rights reserved. Started: 7:00:00 Progress: 2014-02-18 07:00:02.53 Source: {AE173E77-D19E-42CC-B6B3-19CD39BDE479} Executing query "DECLARE @Guid UNIQUEIDENTIFIER EXECUTE msdb..sp...".: 100% complete End Progress Error: 2014-02-18 07:00:03.29 Code: 0xC002F210 Source: Back Up Database (Full) Execute SQL Task Description: Executing the query "BACKUP DATABASE [BEDB] TO DISK = N'e:\SQLBackup\B..." failed with the following error: "Cannot open backup device 'e:\SQLBackup\Backup\BEDB_backup_2014_02_18_070002_8162450.bak'. Operating system error 3(系统找不到指定的路径。). 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 Error: 2014-02-18 07:00:03.34 Code: 0xC002F210 Source: Back Up Database (Full) Execute SQL Task Description: Executing the query "BACKUP DATABASE [DW_develop] TO DISK = N'e:\SQLBa..." failed with the following error: "Cannot open backup device 'e:\SQLBackup\Backup\DW_develop_backup_2014_02_18_070002_8318452.bak'. Operating system error 3(系统找不到指定的路径。). 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 Error: 2014-02-18 07:00:03.36 Code: 0xC002F210 Source: Back Up Database (Full) Execute SQL Task Description: Executing the query "BACKUP DATABASE [EXCEL_develop] TO DISK = N'e:\SQ..." failed with the following error: "Cannot open backup device 'e:\SQLBackup\Backup\EXCEL_develop_backup_2014_02_18_070002_8318452.bak'. Operating system error 3(系统找不到指定的路径。). 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 Error: 2014-02-18 07:00:03.40 Code: 0xC002F210 Source: Back Up Database (Full) Execute SQL Task Description: Executing the query "BACKUP DATABASE [master] TO DISK = N'e:\SQLBackup..." failed with the following error: "Cannot open backup device 'e:\SQLBackup\Backup\master_backup_2014_02_18_070002_8474454.bak'. Operating system error 3(系统找不到指定的路径。). 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 Error: 2014-02-18 07:00:03.42 Code: 0xC002F210 Source: Back Up Database (Full) Execute SQL Task Description: Executing the query "BACKUP DATABASE [model] TO DISK = N'e:\SQLBackup\..." failed with the following error: "Cannot open backup device 'e:\SQLBackup\Backup\model_backup_2014_02_18_070002_8474454.bak'. Operating system error 3(系统找不到指定的路径。). 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 Error: 2014-02-18 07:00:03.45 Code: 0xC002F210 Source: Back Up Database (Full) Execute SQL Task Description: Executing the query "BACKUP DATABASE [msdb] TO DISK = N'e:\SQLBackup\B..." failed with the following error: "Cannot open backup device 'e:\SQLBackup\Backup\msdb_backup_2014_02_18_070002_8630456.bak'. Operating system error 3(系统找不到指定的路径。). 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 Error: 2014-02-18 07:00:03.53 Code: 0xC002F210 Source: Back Up Database (Full) Execute SQL ... The package execution fa... The step failed.