我正在尝试将数据库从远程服务器 (sql server 2008) 复制到我的本地计算机 (运行 sql server express 2014)。一切看起来都很好，直到作业在“执行 SQL Server 代理作业”时失败并显示以下消息：
TITLE: Copy Database Wizard
------------------------------
The job failed. Check the event log on the destination server for details.
------------------------------
BUTTONS:
OK
------------------------------
但我在事件日志中找不到任何异常的内容：
Date,Source,Severity,Message
04/23/2014 15:47:46,spid61,Unknown,Setting database option DB_CHAINING to OFF for database DotNetNukeCTSI5.
04/23/2014 15:47:46,spid61,Unknown,Setting database option PAGE_VERIFY to CHECKSUM for database DotNetNukeCTSI5.
04/23/2014 15:47:46,spid61,Unknown,Setting database option MULTI_USER to ON for database DotNetNukeCTSI5.
04/23/2014 15:47:46,spid61,Unknown,Setting database option RECOVERY to FULL for database DotNetNukeCTSI5.
04/23/2014 15:47:46,spid61,Unknown,Setting database option READ_WRITE to ON for database DotNetNukeCTSI5.
04/23/2014 15:47:46,spid61,Unknown,Setting database option HONOR_BROKER_PRIORITY to OFF for database DotNetNukeCTSI5.
04/23/2014 15:47:46,spid61,Unknown,Setting database option READ_COMMITTED_SNAPSHOT to OFF for database DotNetNukeCTSI5.
04/23/2014 15:47:46,spid61,Unknown,Setting database option PARAMETERIZATION to SIMPLE for database DotNetNukeCTSI5.
04/23/2014 15:47:46,spid61,Unknown,Setting database option ALLOW_SNAPSHOT_ISOLATION to OFF for database DotNetNukeCTSI5.
04/23/2014 15:47:46,spid61,Unknown,Setting database option TRUSTWORTHY to OFF for database DotNetNukeCTSI5.
04/23/2014 15:47:46,spid61,Unknown,Setting database option DATE_CORRELATION_OPTIMIZATION to OFF for database DotNetNukeCTSI5.
04/23/2014 15:47:46,spid61,Unknown,Setting database option AUTO_UPDATE_STATISTICS_ASYNC to OFF for database DotNetNukeCTSI5.
04/23/2014 15:47:46,spid61,Unknown,Setting database option DISABLE_BROKER to ON for database DotNetNukeCTSI5.
04/23/2014 15:47:46,spid61,Unknown,Setting database option RECURSIVE_TRIGGERS to OFF for database DotNetNukeCTSI5.
04/23/2014 15:47:46,spid61,Unknown,Setting database option QUOTED_IDENTIFIER to OFF for database DotNetNukeCTSI5.
04/23/2014 15:47:46,spid61,Unknown,Setting database option NUMERIC_ROUNDABORT to OFF for database DotNetNukeCTSI5.
04/23/2014 15:47:46,spid61,Unknown,Setting database option CONCAT_NULL_YIELDS_NULL to OFF for database DotNetNukeCTSI5.
04/23/2014 15:47:46,spid61,Unknown,Setting database option CURSOR_DEFAULT to GLOBAL for database DotNetNukeCTSI5.
04/23/2014 15:47:46,spid61,Unknown,Setting database option CURSOR_CLOSE_ON_COMMIT to OFF for database DotNetNukeCTSI5.
04/23/2014 15:47:46,spid61,Unknown,Setting database option AUTO_UPDATE_STATISTICS to ON for database DotNetNukeCTSI5.
04/23/2014 15:47:46,spid61,Unknown,Setting database option AUTO_SHRINK to OFF for database DotNetNukeCTSI5.
04/23/2014 15:47:46,spid61,Unknown,Setting database option AUTO_CREATE_STATISTICS to ON for database DotNetNukeCTSI5.
04/23/2014 15:47:46,spid61,Unknown,Setting database option AUTO_CLOSE to OFF for database DotNetNukeCTSI5.
04/23/2014 15:47:46,spid61,Unknown,Setting database option ARITHABORT to OFF for database DotNetNukeCTSI5.
04/23/2014 15:47:46,spid61,Unknown,Setting database option ANSI_WARNINGS to OFF for database DotNetNukeCTSI5.
04/23/2014 15:47:46,spid61,Unknown,Setting database option ANSI_PADDING to OFF for database DotNetNukeCTSI5.
04/23/2014 15:47:46,spid61,Unknown,Setting database option ANSI_NULLS to OFF for database DotNetNukeCTSI5.
04/23/2014 15:47:46,spid61,Unknown,Setting database option ANSI_NULL_DEFAULT to OFF for database DotNetNukeCTSI5.
04/23/2014 15:47:46,spid61,Unknown,Setting database option COMPATIBILITY_LEVEL to 100 for database DotNetNukeCTSI5.
04/23/2014 15:47:46,spid61,Unknown,Starting up database 'DotNetNukeCTSI5'.
04/23/2014 15:37:32,spid57,Unknown,AppDomain 2 (mssqlsystemresource.sys[runtime].1) created.
04/23/2014 15:37:31,spid57,Unknown,Common language runtime (CLR) functionality initialized using CLR version v2.0.50727 from C:\Windows\Microsoft.NET\Framework64\v2.0.50727\.
04/23/2014 15:37:27,spid57,Unknown,Setting database option DB_CHAINING to OFF for database DotNetNukeCTSI5.
04/23/2014 15:37:27,spid57,Unknown,Setting database option PAGE_VERIFY to CHECKSUM for database DotNetNukeCTSI5.
04/23/2014 15:37:27,spid57,Unknown,Setting database option MULTI_USER to ON for database DotNetNukeCTSI5.
04/23/2014 15:37:27,spid57,Unknown,Setting database option RECOVERY to FULL for database DotNetNukeCTSI5.
04/23/2014 15:37:27,spid57,Unknown,Setting database option READ_WRITE to ON for database DotNetNukeCTSI5.
04/23/2014 15:37:27,spid57,Unknown,Setting database option HONOR_BROKER_PRIORITY to OFF for database DotNetNukeCTSI5.
04/23/2014 15:37:27,spid57,Unknown,Setting database option READ_COMMITTED_SNAPSHOT to OFF for database DotNetNukeCTSI5.
04/23/2014 15:37:27,spid57,Unknown,Setting database option PARAMETERIZATION to SIMPLE for database DotNetNukeCTSI5.
04/23/2014 15:37:27,spid57,Unknown,Setting database option ALLOW_SNAPSHOT_ISOLATION to OFF for database DotNetNukeCTSI5.
04/23/2014 15:37:27,spid57,Unknown,Setting database option TRUSTWORTHY to OFF for database DotNetNukeCTSI5.
04/23/2014 15:37:27,spid57,Unknown,Setting database option DATE_CORRELATION_OPTIMIZATION to OFF for database DotNetNukeCTSI5.
04/23/2014 15:37:27,spid57,Unknown,Setting database option AUTO_UPDATE_STATISTICS_ASYNC to OFF for database DotNetNukeCTSI5.
04/23/2014 15:37:27,spid57,Unknown,Setting database option DISABLE_BROKER to ON for database DotNetNukeCTSI5.
04/23/2014 15:37:27,spid57,Unknown,Setting database option RECURSIVE_TRIGGERS to OFF for database DotNetNukeCTSI5.
04/23/2014 15:37:27,spid57,Unknown,Setting database option QUOTED_IDENTIFIER to OFF for database DotNetNukeCTSI5.
04/23/2014 15:37:27,spid57,Unknown,Setting database option NUMERIC_ROUNDABORT to OFF for database DotNetNukeCTSI5.
04/23/2014 15:37:27,spid57,Unknown,Setting database option CONCAT_NULL_YIELDS_NULL to OFF for database DotNetNukeCTSI5.
04/23/2014 15:37:27,spid57,Unknown,Setting database option CURSOR_DEFAULT to GLOBAL for database DotNetNukeCTSI5.
04/23/2014 15:37:27,spid57,Unknown,Setting database option CURSOR_CLOSE_ON_COMMIT to OFF for database DotNetNukeCTSI5.
04/23/2014 15:37:27,spid57,Unknown,Setting database option AUTO_UPDATE_STATISTICS to ON for database DotNetNukeCTSI5.
04/23/2014 15:37:27,spid57,Unknown,Setting database option AUTO_SHRINK to OFF for database DotNetNukeCTSI5.
04/23/2014 15:37:27,spid57,Unknown,Setting database option AUTO_CREATE_STATISTICS to ON for database DotNetNukeCTSI5.
04/23/2014 15:37:27,spid57,Unknown,Setting database option AUTO_CLOSE to OFF for database DotNetNukeCTSI5.
04/23/2014 15:37:27,spid57,Unknown,Setting database option ARITHABORT to OFF for database DotNetNukeCTSI5.
04/23/2014 15:37:27,spid57,Unknown,Setting database option ANSI_WARNINGS to OFF for database DotNetNukeCTSI5.
04/23/2014 15:37:27,spid57,Unknown,Setting database option ANSI_PADDING to OFF for database DotNetNukeCTSI5.
04/23/2014 15:37:27,spid57,Unknown,Setting database option ANSI_NULLS to OFF for database DotNetNukeCTSI5.
04/23/2014 15:37:27,spid57,Unknown,Setting database option ANSI_NULL_DEFAULT to OFF for database DotNetNukeCTSI5.
04/23/2014 15:37:27,spid57,Unknown,Setting database option COMPATIBILITY_LEVEL to 100 for database DotNetNukeCTSI5.
04/23/2014 15:37:27,spid57,Unknown,Starting up database 'DotNetNukeCTSI5'.
04/23/2014 15:33:27,spid58,Unknown,Using 'xpsqlbot.dll' version '2009.100.1600' to execute extended stored procedure 'xp_qv'. This is an informational message only; no user action is required.
04/23/2014 15:33:27,spid58,Unknown,Attempting to load library 'xpsqlbot.dll' into memory. This is an informational message only. No user action is required.
04/23/2014 15:33:27,spid58,Unknown,FILESTREAM: effective level = 0<c/> configured level = 0<c/> file system access share name = 'DWYATTMSSQL'.
04/23/2014 15:33:27,spid58,Unknown,Configuration option 'show advanced options' changed from 1 to 0. Run the RECONFIGURE statement to install.
04/23/2014 15:33:27,spid58,Unknown,FILESTREAM: effective level = 0<c/> configured level = 0<c/> file system access share name = 'DWYATTMSSQL'.
04/23/2014 15:33:27,spid58,Unknown,Configuration option 'Agent XPs' changed from 0 to 1. Run the RECONFIGURE statement to install.
04/23/2014 15:33:27,spid58,Unknown,FILESTREAM: effective level = 0<c/> configured level = 0<c/> file system access share name = 'DWYATTMSSQL'.
04/23/2014 15:33:27,spid58,Unknown,Configuration option 'show advanced options' changed from 0 to 1. Run the RECONFIGURE statement to install.
04/23/2014 15:33:27,,Warning,[396] An idle CPU condition has not been defined - OnIdle job schedules will have no effect
04/23/2014 15:33:27,,Warning,[260] Unable to start mail session (reason: No mail profile defined)
04/23/2014 15:33:27,,Information,[129] SQLAgent$DWYATTMSSQL starting under Windows NT service control
04/23/2014 15:33:27,,Error,[364] The Messenger service has not been started - NetSend notifications will not be sent
04/23/2014 15:33:27,,Information,[432] There are 12 subsystems in the subsystems cache
04/23/2014 15:33:27,,Information,[339] Local computer is KMCNUTT-7 running Windows NT 6.2 (9200)
04/23/2014 15:33:27,,Information,[310] 4 processor(s) and 8067 MB RAM detected
04/23/2014 15:33:27,,Information,[103] NetLib being used by driver is DBNETLIB.DLL; Local host server is KMCNUTT-7\DWYATTMSSQL
04/23/2014 15:33:27,,Information,[102] SQL Server ODBC driver version 10.50.1600
04/23/2014 15:33:27,,Information,[101] SQL Server KMCNUTT-7\DWYATTMSSQL version 10.50.1600 (0 connection limit)
04/23/2014 15:33:27,,Information,[100] Microsoft SQLServerAgent version 10.50.1600.1 ((Unknown) unicode retail build) : Process ID 2008
04/23/2014 15:17:55,spid57,Unknown,Using 'xplog70.dll' version '2009.100.1600' to execute extended stored procedure 'xp_msver'. This is an informational message only; no user action is required.
04/23/2014 15:17:55,spid57,Unknown,Attempting to load library 'xplog70.dll' into memory. This is an informational message only. No user action is required.
04/23/2014 15:17:25,Logon,Unknown,Login failed for user 'sa'. Reason: Password did not match that for the login provided. [CLIENT: <local machine>]
04/23/2014 15:17:25,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 8.
04/23/2014 13:13:13,spid52,Unknown,Setting database option PAGE_VERIFY to CHECKSUM for database DNN5.
04/23/2014 13:13:13,spid52,Unknown,Setting database option MULTI_USER to ON for database DNN5.
04/23/2014 13:13:13,spid52,Unknown,Setting database option RECOVERY to FULL for database DNN5.
04/23/2014 13:13:13,spid52,Unknown,Setting database option READ_WRITE to ON for database DNN5.
04/23/2014 13:13:13,spid52,Unknown,Setting database option READ_COMMITTED_SNAPSHOT to OFF for database DNN5.
04/23/2014 13:13:13,spid52,Unknown,Setting database option PARAMETERIZATION to SIMPLE for database DNN5.
04/23/2014 13:13:13,spid52,Unknown,Setting database option DATE_CORRELATION_OPTIMIZATION to OFF for database DNN5.
04/23/2014 13:13:13,spid52,Unknown,Setting database option AUTO_UPDATE_STATISTICS_ASYNC to OFF for database DNN5.
04/23/2014 13:13:13,spid52,Unknown,Setting database option DISABLE_BROKER to ON for database DNN5.
04/23/2014 13:13:13,spid52,Unknown,Setting database option RECURSIVE_TRIGGERS to OFF for database DNN5.
04/23/2014 13:13:13,spid52,Unknown,Setting database option QUOTED_IDENTIFIER to OFF for database DNN5.
04/23/2014 13:13:13,spid52,Unknown,Setting database option NUMERIC_ROUNDABORT to OFF for database DNN5.
04/23/2014 13:13:13,spid52,Unknown,Setting database option CONCAT_NULL_YIELDS_NULL to OFF for database DNN5.
04/23/2014 13:13:13,spid52,Unknown,Setting database option CURSOR_DEFAULT to GLOBAL for database DNN5.
04/23/2014 13:13:13,spid52,Unknown,Setting database option CURSOR_CLOSE_ON_COMMIT to OFF for database DNN5.
04/23/2014 13:13:13,spid52,Unknown,Setting database option AUTO_UPDATE_STATISTICS to ON for database DNN5.
04/23/2014 13:13:13,spid52,Unknown,Setting database option AUTO_CREATE_STATISTICS to ON for database DNN5.
04/23/2014 13:13:13,spid52,Unknown,Setting database option AUTO_SHRINK to OFF for database DNN5.
04/23/2014 13:13:13,spid52,Unknown,Setting database option AUTO_CLOSE to OFF for database DNN5.
04/23/2014 13:13:13,spid52,Unknown,Setting database option ARITHABORT to OFF for database DNN5.
04/23/2014 13:13:13,spid52,Unknown,Setting database option ANSI_WARNINGS to OFF for database DNN5.
04/23/2014 13:13:13,spid52,Unknown,Setting database option ANSI_PADDING to OFF for database DNN5.
04/23/2014 13:13:13,spid52,Unknown,Setting database option ANSI_NULLS to OFF for database DNN5.
04/23/2014 13:13:13,spid52,Unknown,Setting database option ANSI_NULL_DEFAULT to OFF for database DNN5.
04/23/2014 13:13:12,spid52,Unknown,Setting database option COMPATIBILITY_LEVEL to 100 for database DNN5.
04/23/2014 13:13:12,spid52,Unknown,Starting up database 'DNN5'.
04/23/2014 13:12:58,spid52,Unknown,Using 'xpstar.dll' version '2009.100.1600' to execute extended stored procedure 'xp_instance_regread'. This is an informational message only; no user action is required.
04/23/2014 13:12:58,spid52,Unknown,Attempting to load library 'xpstar.dll' into memory. This is an informational message only. No user action is required.
04/23/2014 13:08:49,spid6s,Unknown,Recovery is complete. This is an informational message only. No user action is required.
答案1
检查 SQLAGENT.OUT 中是否存在任何相关错误。