Can anyone help me?
When i Use the copy database wizard @.sql 2005 at the last step
i get these 2 Error's in the log's
Event Type: Warning
Event Source: SQLSERVERAGENT
Event Category: Job Engine
Event ID: 208
SQL Server Scheduled Job 'CDW_NAME_0' (0x883C948F64FCAA49BEA22068F4C7E15A) - Status: Failed - Invoked on: 2006-08-14 13:28:19 - Message: The job failed. The Job was invoked by User Domain\Administrator. The last step to run was step 1 (CDW_NAME_0_Step).
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Event Type: Error
Event Source: SQLISPackage
Event Category: None
Event ID: 12291
Package "CDW_NAME_0" failed.
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.I have the same error on SQL 2005 enterprise, am trying to copy a 2000 database into 2005. Should work but fails on copy.|||
I'm moving this over to the tools forum since they have more experience with CDW.
what is the service pack on this box. You should apply SP2 and also check whether SSIS (Integration Service) is installed or not
Madhu|||THERE IS SP2 AND THE INTEGRATION SERVICE IS STARTED AS ADMNISTRATORsql