September 8, 2003 at 4:05 am
Hi, when I try to run a DTS package to copy database between two SQL servers it aborts with "undefined error"
* Both servers are SQL 2000 enterprise with SP3
* Servers are in two different boxes, one runs Win 2003 server, the other runs win 2000 server
* Login to both servers as "sa" during DTS design
* Destination server has enough space for the data and log files
* Destination server runs under an account that has entitlements to copy files accross network.
Am I missing somthing??
EM
September 8, 2003 at 9:39 am
I've found that this process can be problematic. Usually there is some rights issue. If you double click the line wiht the error, is the error mentioned above the one that returns?
Can you run a profiler trace of the process and see what happens?
Steve Jones
http://qa.sqlservercentral.com/columnists/sjones
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
September 9, 2003 at 12:41 am
quote:
I've found that this process can be problematic. Usually there is some rights issue. If you double click the line wiht the error, is the error mentioned above the one that returns?Can you run a profiler trace of the process and see what happens?
Steve Jones
Hi, here are more info:-
* no users are connected to source database
* connection to source and target servers are OK from QA and EM
* package consists of one step only (copy database)
* package aborts immediately when run with "error occured", when double click it displays "unspecified error"
* profiler trace doesn't seem very helpful
EM
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply