We are running SQL 7 on a Windows NT Server. If you copy a 25Mb file
from this machine to a W2K server, the file copy takes over 5 minutes
on a 100Mpbs switched network.

Copying the same file to another NT server takes only seconds, and
copying the same file to the W2K server from the 2nd NT server, (which
is not running SQL) takes only seconds also.

Has anyone any ideas as to why file copying between this machine and a
W2K one will take so long. It is repliacted on 5 further w2K machines.

Hi

There can be several reasons for this, some are:

Pour network connections or contention to the given server
Defragmentation of the destination either sets of disks
Corruption of the file system
Corruption of the discs

Look at doing some network analysis and check the hardware/os diagnostic
facilities for the given server. You should also try the file copy when the
services are not running on the destination server.

HTH

John

"John Finch" <john_finch@europe.bd.com> wrote in message
news:d78127dd.0311070430.7e66df48@posting.google.c om...
> We are running SQL 7 on a Windows NT Server. If you copy a 25Mb file
> from this machine to a W2K server, the file copy takes over 5 minutes
> on a 100Mpbs switched network.
>
> Copying the same file to another NT server takes only seconds, and
> copying the same file to the W2K server from the 2nd NT server, (which
> is not running SQL) takes only seconds also.
>
> Has anyone any ideas as to why file copying between this machine and a
> W2K one will take so long. It is repliacted on 5 further w2K machines.