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

Use Copyto or Mirror

dklein9930dklein9930 Posts: 20
edited May 17, 2011 11:50PM in SQL Backup Previous Versions
Hey All,

I need to copy a full backup to a reporting server with a fixed name. The local copy gets an auto name. Can I use copyto to rename or choose a different name than the <auto.sqb> name given to the original file? Or, do I need to use Mirror to name the backup file for the report server?



  • Options
    peteypetey Posts: 2,358 New member
    COPYTO only accepts directory names. MIRRORFILE accepts file names, so yes, you would need to use the MIRRORFILE option if you want to name the backup file differently on your reporting server.
    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.