Copy Backup File to different server

[scabral79]

Hi,

i need to restore a production backup to a database on a seperate test server. What is the best way to copy the backup (16GB) from the prod server to the Test server? Should i just use ActiveX script to copy the file over or try to create an ftp script? Which is faster?

 

[MDXer]

if you can copy to a unc then I would xcopy the file over then restore it.

Paul
---------------------------------------
Shoot Me! Shoot Me NOW!!!
- Daffy Duck