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? |