SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 copy file or use package ftp to copy backup
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

rongrzywacz
Yak Posting Veteran

USA
57 Posts

Posted - 12/20/2001 :  15:30:44  Show Profile  Reply with Quote
I need to copy a 20G db backup file from one server to another nightly. They are on the same network. Would it be quicker to use the FTP transfer task in a package or the EXEC xp_cmdshell 'copy ... ' in a exec SQL task to move the file. It is important that I get a return code back to take different courses of action in the case of errors.
Thanks for any help!


Ron Grzywacz

chadmat
The Chadinator

USA
1974 Posts

Posted - 12/20/2001 :  15:35:16  Show Profile  Visit chadmat's Homepage  Reply with Quote
I'm not sure if this is a possability for you, but I have found it to be a lot quicker to backup to the remote location directly (Use a UNC)rather than backup and then copy. Copying a 20 GB file will probably take quite a while (In my experience it has anyway).

HTH
-Chad

Go to Top of Page

rongrzywacz
Yak Posting Veteran

USA
57 Posts

Posted - 12/20/2001 :  15:49:33  Show Profile  Reply with Quote
Not that is an option right now. I need to keep a backup on both servers. And the target server is not always available at the time of the backup.
The local backup takses, 1/2hr, but the copy takes about 2hrs and kills the network.
Thanks for the help.



Ron Grzywacz
Go to Top of Page

izaltsman
A custom title

USA
1139 Posts

Posted - 12/20/2001 :  16:05:25  Show Profile  Send izaltsman an AOL message  Send izaltsman an ICQ Message  Reply with Quote
Ron,
FTP will probably be slower than straight copy. I'd stick with EXEC xp_cmdshell 'copy ... ' if I were you.

Instead of having your database backed up onto a single backup device, I would suggest striping backup accross several backup devices. That way, the size of each device file is much smaller, and therefore files are more manageable... You can use zip (may not work on very large files) or rar (a bit slower, but works on just about anything) to compress the files prior to copying.



Edited by - izaltsman on 12/20/2001 16:06:09
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000