What are the challenges you face when working across database platforms? Take the survey
Options

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?

Comments

  • Options
    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.
  • Options
    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
Sign In or Register to comment.