COPYTO option speed

francisdfrancisd Posts: 2
edited October 9, 2008 10:27PM in SQL Backup Previous Versions
We are using the COPYTO option with our backups. Is there a way to speed up the COPYTO process?
· Share on Twitter

Comments

  • brosatobrosato Posts: 89 Bronze 2
    francisd wrote:
    We are using the COPYTO option with our backups. Is there a way to speed up the COPYTO process?

    I would say it's soley dependant on your network speed.
    · Share on Twitter
  • peteypetey Posts: 2,358 New member
    The COPYTO option uses the WinAPI file copy functions to perform the task. Is the copying process on your system slower than if you were to copy the same file manually to the same location?
    Peter Yeoh
    SQL Backup Consultant Developer
    Associate, Yohz Software
    Beyond compression - SQL Backup goodies under the hood, updated for version 8
    · Share on Twitter
Sign In or Register to comment.