Sql Server 2005 - Copy Database
-
Hello I am using Sql Server 2005. I have two different servers. I was trying to use the wizard of Copy Database in order to copy a DB from one server to the other. After arriving to the last stage where the copying process starts, I get an error in the field of Execute SQL Server Agent JOB : The job failed. Check the event log on the destination server for details. and on the destination server in the event log I get the message : Package "CDW_DT-A1_MLS09_1" failed. where DT-A1 is the source server and MLS09 is the second server. Anyone has ideas how to overcome this problem ? Thanks, Clint
-
Hello I am using Sql Server 2005. I have two different servers. I was trying to use the wizard of Copy Database in order to copy a DB from one server to the other. After arriving to the last stage where the copying process starts, I get an error in the field of Execute SQL Server Agent JOB : The job failed. Check the event log on the destination server for details. and on the destination server in the event log I get the message : Package "CDW_DT-A1_MLS09_1" failed. where DT-A1 is the source server and MLS09 is the second server. Anyone has ideas how to overcome this problem ? Thanks, Clint
You may want to check what you are trying to copy. For instance, if you try to copy a database user/role across - this might be causing it to fail.
Deja View - the feeling that you've seen this post before.
-
You may want to check what you are trying to copy. For instance, if you try to copy a database user/role across - this might be causing it to fail.
Deja View - the feeling that you've seen this post before.