dbTalk Databases Forums  

copy error

microsoft.public.sqlserver.server microsoft.public.sqlserver.server


Discuss copy error in the microsoft.public.sqlserver.server forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Tech - SBT
 
Posts: n/a

Default copy error - 10-16-2003 , 02:58 PM






Can someone point me in the right direction to figure out
what's wrong here?

I'm trying to copy a very simple DB between two servers
using the SQL 2000 Enterprise Manager DB Copy Wizard. All
steps looks good up to detaching the source DB, but then
the actual copy of the share database mdf file to the
destination server fails. The Error Code in the Task
Detail box is 'failed'. The Error Code in the Step Detail
box is '-2147467259'.

The Package Log Error Description is:

Step Error Source: Microsoft Data Transformation Services
(DTS) Package
Step Error Description:Unspecified error

Step Error code: 80004005
Step Error Help File:sqldts80.hlp
Step Error Help Context ID:1100



Reply With Quote
  #2  
Old   
I_AM_DON_AND_YOU?
 
Posts: n/a

Default Re: copy error - 10-16-2003 , 04:04 PM






The reason and solution to your exact error/problem are given at:

http://support.microsoft.com/default...&Product=sql2k


"Tech - SBT" <bglynn (AT) sbtontheweb (DOT) com> wrote

Quote:
Can someone point me in the right direction to figure out
what's wrong here?

I'm trying to copy a very simple DB between two servers
using the SQL 2000 Enterprise Manager DB Copy Wizard. All
steps looks good up to detaching the source DB, but then
the actual copy of the share database mdf file to the
destination server fails. The Error Code in the Task
Detail box is 'failed'. The Error Code in the Step Detail
box is '-2147467259'.

The Package Log Error Description is:

Step Error Source: Microsoft Data Transformation Services
(DTS) Package
Step Error Description:Unspecified error

Step Error code: 80004005
Step Error Help File:sqldts80.hlp
Step Error Help Context ID:1100





Reply With Quote
  #3  
Old   
Tech - SBT
 
Posts: n/a

Default Re: copy error - 10-16-2003 , 05:01 PM



I read that and don't see the exact problem. MORE INFO does not give me any
details nor an exact error.



"I_AM_DON_AND_YOU?" <user (AT) domain (DOT) com> wrote

Quote:
The reason and solution to your exact error/problem are given at:


http://support.microsoft.com/default...&Product=sql2k


"Tech - SBT" <bglynn (AT) sbtontheweb (DOT) com> wrote in message
news:1MCjb.147527$Of2.4215035 (AT) twister (DOT) tampabay.rr.com...
Can someone point me in the right direction to figure out
what's wrong here?

I'm trying to copy a very simple DB between two servers
using the SQL 2000 Enterprise Manager DB Copy Wizard. All
steps looks good up to detaching the source DB, but then
the actual copy of the share database mdf file to the
destination server fails. The Error Code in the Task
Detail box is 'failed'. The Error Code in the Step Detail
box is '-2147467259'.

The Package Log Error Description is:

Step Error Source: Microsoft Data Transformation Services
(DTS) Package
Step Error Description:Unspecified error

Step Error code: 80004005
Step Error Help File:sqldts80.hlp
Step Error Help Context ID:1100








Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.