Guest Peter Posted December 13, 2007 Posted December 13, 2007 Hi, We have to restore a SQL Server database from backup that is of size around 20GB. However, the backup staff restore it to another server that runs as IIS + FTP Server (Not the one where SQL Server installed). We have attempted to transfer the file from the FTP Server but not successful. And we would like to know what is the best way to copy the file across ? Thanks Peter
Guest Jabez Gan [MVP] Posted December 13, 2007 Posted December 13, 2007 Re: What is the best way to transfer a file of size around 20GB ? Before we can suggest, we need to know how are those servers connected? WAN/LAN? What's the speed? If the file is now on the FTP Server, did you try downloading the file off the FTP Server? If the file is not on a FTP Server, get a temporary FTP server running on that server, and use the other computer to download the file off that FTP Servr. Use a download manager to download from the FTP server (if it's on a WAN). This ensures that the download is resumable. -- Jabez Gan Microsoft MVP: Windows Server - File Storage "Peter" <Peter@discussions.microsoft.com> wrote in message news:uby12hVPIHA.1184@TK2MSFTNGP04.phx.gbl... > Hi, > > We have to restore a SQL Server database from backup that is of size > around 20GB. However, the backup staff restore it to another server that > runs as IIS + FTP Server (Not the one where SQL Server installed). > > We have attempted to transfer the file from the FTP Server but not > successful. And we would like to know what is the best way to copy the > file across ? > > Thanks > Peter >
Guest Peter Posted December 15, 2007 Posted December 15, 2007 Re: What is the best way to transfer a file of size around 20GB ? Dear Jabez, Both servers are connected via LAN. I have attempted to transfer the file via FTP (Drag the data across in Windows Explorer). I try to copy the data to D drive of the SQL Server, however, I observe that there is a TMP file grows in the C drive instead. Since there are only around 7GB free space in C drive, copy fails. In this way, I think that it is the problem of file size > 2GB. Regards Peter "Jabez Gan [MVP]" <mingteikg@blizNOSPAMhosting.com> wrote in message news:BA4CC20B-EE4B-4F0E-BFE0-59E5AA99AAB4@microsoft.com... > Before we can suggest, we need to know how are those servers connected? > WAN/LAN? What's the speed? > > If the file is now on the FTP Server, did you try downloading the file off > the FTP Server? > > If the file is not on a FTP Server, get a temporary FTP server running on > that server, and use the other computer to download the file off that FTP > Servr. Use a download manager to download from the FTP server (if it's on > a WAN). This ensures that the download is resumable. > > -- > Jabez Gan > Microsoft MVP: Windows Server - File Storage > "Peter" <Peter@discussions.microsoft.com> wrote in message > news:uby12hVPIHA.1184@TK2MSFTNGP04.phx.gbl... >> Hi, >> >> We have to restore a SQL Server database from backup that is of size >> around 20GB. However, the backup staff restore it to another server that >> runs as IIS + FTP Server (Not the one where SQL Server installed). >> >> We have attempted to transfer the file from the FTP Server but not >> successful. And we would like to know what is the best way to copy the >> file across ? >> >> Thanks >> Peter >> >
Guest Leythos Posted December 15, 2007 Posted December 15, 2007 Re: What is the best way to transfer a file of size around 20GB ? In article <#0L3v#qPIHA.6036@TK2MSFTNGP03.phx.gbl>, Peter@discussions.microsoft.com says... > Dear Jabez, > > Both servers are connected via LAN. > > I have attempted to transfer the file via FTP (Drag the data across in > Windows Explorer). > > I try to copy the data to D drive of the SQL Server, however, I observe that > there is a TMP file grows in the C drive instead. Since there are only > around 7GB free space in C drive, copy fails. > > In this way, I think that it is the problem of file size > 2GB. Download the Windows 2003 Resource Kit, it's free, then use ROBOCOPY to move it across your network. It's fast, low overhead, and it logs the status of the file move. Why would you use FTP if they are on the same LAN? Just copy, xcopy, robocopy.... -- Leythos - Igitur qui desiderat pacem, praeparet bellum. - Calling an illegal alien an "undocumented worker" is like calling a drug dealer an "unlicensed pharmacist" spam999free@rrohio.com (remove 999 for proper email address)
Recommended Posts