Issue copying SQL database from 2005 to 2008r2
Posted on 2010-11-24
i am in the process of moving one of my sql databases to my new server.
My database is currently on SQL 2005 and i want to move it to my new one that is on a different domain and is running SQL 2008 R2.
Every time i use the copy database feature i keep getting this error just before finish.
SQL Server Scheduled Job 'CDW_HERCULES_ARES_MSSQLSERVERR2_12_1' (0xA813AF26FFBAFB4D96E295E0CEAB595E) - Status: Failed - Invoked on: 2010-11-25 14:57:14 - Message: The job failed. The Job was invoked by User SCORPTEC\Administrator. The last step to run was step 1 (CDW_HERCULES_ARES_MSSQLSERVERR2_12_1_Step).
any help would me much appreciated