Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
raginbullsht
Starting Member
8 Posts |
 Posted - 2010-02-23 : 15:33:47
|
| I am using the copy database wizard to copy a database from one server to another. The wizard walks me through the entire process, but when I go to finish I get an error on Execute SQL Server Agent Job.Performing operation...- Add log for package (Success)- Add task for transferring database objects (Success)- Create package (Success)- Start SQL Server Agent Job (Success)- Execute SQL Server Agent Job (Error)MessagesThe job failed. Check the event log on the destination server for details. (Copy Database Wizard)Destination server log showsSQL Server Scheduled Job 'CDW_GIS-SERVER_SQL2_4' (0x609912449371F94CA023CE22A3C0024C) - Status: Failed - Invoked on: 2010-02-23 15:25:51 - Message: The job failed. The Job was invoked by User ADMINBLDG\jhome. The last step to run was step 1 (CDW_GIS-SERVER_SQL2_4_Step).For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.if anyone has a good idea of what is going on I would appreciate the help. Thanks |
|
|
DaleTurley
Yak Posting Veteran
76 Posts |
Posted - 2010-02-23 : 17:08:56
|
| When you view the failed job at the destination, view the step history this will give some more detail as to why the step failed as appose to the job history which tells you what step failed.Post it back here if it doesn't make sense. |
 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2010-02-24 : 08:02:05
|
| Use Backup\Restore Method instead. |
|
|
|
|
|
|
Copy database from one SQL to another