dbTalk Databases Forums  

Info about tasks

microsoft.public.sqlserver.programming microsoft.public.sqlserver.programming


Discuss Info about tasks in the microsoft.public.sqlserver.programming forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Enric
 
Posts: n/a

Default Info about tasks - 04-19-2005 , 12:29 PM






Dear all,

I have got a EXPORT task between a Sql Server to my local SQL (within one
same domain) and apparently everything is fine, it is doing a copy about 100
tables with an average of 2,000 rows per each table.


As you will see there is no locks or hindrances or something like that:

Source Sql Server task:

56 sleeping servers NWP-91 .
CO_WH_DEVE AWAITING COMMAND 78 238 04/19 18:25:18 DTS Import/Export
Wizard 56

Destination Sql Server task:

56 RUNNABLE SERVERS NWP-91 . CO_WH_DEVE BULK
INSERT 364500 237066 04/19 18:25:20 DTS Import/Export Wizard 56


Definitely there is no tasks or processes running against the tables that
right now is being transferred as well as Front-End and Back-End applications
are closed (Visual Basic 6.0 app)

The question, maybe silly question, is the following: how could I know if is
there anything going wrong?

Thanks in advance and regards,


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.