Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 484
  • Last Modified:

copy database wizard error in sql server 2005

I want to copy a database between seperate sql server 2005 by using copy database wizard but I get error with "Execute sql server agent job error" when I run immediately this wizard..I looked at the destination server and I see "Package "cdw_sourceservername_destinationserver"failed..
eventid:12291 and SQLISPackage...how can I solve this problem?
0
teodor76
Asked:
teodor76
  • 2
1 Solution
 
JulianvaCommented:
Make sure that the path on the destination server exists , example

if on the the source you have the data files on D:\ and log files on E:
it is possible that the destination do not have theses drives and the wizard is trying to copy the data and log files to a path that does not exist. Check your path on the destination.

or
You do not have permissions to execute a copy database job. You might need sysadmin permissions on both servers to copy a database.

Why you using the wizard , just backup the database - copy the bak file to the destination then restore.






0
 
JulianvaCommented:
Hi Teodor

I gave you three possible solutions, which one worked for you.

0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now