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


fhanlonfhanlon Posts: 17 Bronze 2
edited June 9, 2005 10:10PM in SQL Backup Previous Versions
What is the difference between COPYTO and the MIRRORFILE extensions to the Backup command? The help file doesn't make it clear. It seems like they both create a copy of the backup file.


  • Options
    peteypetey Posts: 2,358 New member
    COPYTO copies the backup file to x locations after it has been generated. Thus, only one backup file is generated.

    MIRRORFILE creates multiple copies of the backup file as it is generated. As long as one location is still writable, the backup will proceed.
    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.