dbTalk Databases Forums  

SQL DTS and DFS

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss SQL DTS and DFS in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
paul_tomlin@hotmail.com
 
Posts: n/a

Default SQL DTS and DFS - 02-02-2006 , 01:24 PM






Overview
We have a server that is struggling with the load (Email, AD, DHCP,
DNS, WINS, File & Print) and is running too low on disk space to run
any management tools against the *.EDB.
We have another server with enough disk space and low utilisation we
would like to move the file share across too.

Problem
We have a number of SQL DTS jobs that point directly to the UNC. Also
a number of other 3rd party products that look directly for the UNC.

Question
Moving the files and utilising DFS will we gain any benefit. i.e. Will
the application (or client) talk directly to the new server(location)
or will everything still be processed through the original server? I
understand the first call will be processed through the current server
but all subsequent calls then managed by the remote DFS server?


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 - 2012, Jelsoft Enterprises Ltd.