moving...

Hi ,

We have a database around 5GB in size, located in remote location . i want to get that database into my local machine. We cannot take back up in tape or any other media from our remote location ,so we have to depend on FTP .

Is there any better solution other than FTP, or DTS import/Export , to transfer whole database to my local machine ?

Please give me some suggestions !

Thanks,

HadleyIts better to take file backup and use FTP to transfer the file. Before than make sure to run DBCC checks against the database to keep it clean.

Even you can use Generate SQL Scripts and run those scripts on the local machine, then use DTS to transfer the data.

HTH