Copy database wizard given while copy and the job failed.

Question

Hi all,

error - Check the event log on the destination server for details at sql server 2008 r2

I am using copy wizard in sql server 2008 r2 machine to copy a database to another sql server 2008 r2 machine.

i not sure why?? Need help regarding this issue.

How to solve this???

Regards

Hafizah

Answer 1

Hello,

Please make sure SQL Server agent is started on both SQL Server instances.

You must be a sysadmin on both instances also.

Please examine Application event log using the following article:

http://windows.microsoft.com/en-US/windows-vista/Open-Event-Viewer

Hope this helps.

Regards,

Alberto Morillo
SQLCoffee.com