How can we help you today? How can we help you today?

Copy to network and multiple folders

When backing up multiple jobs and using copy to network, why does it copy them all to the same folder? It should use the the same options as it does when it creates the local file and create seperate directories for each database. Am I missing something?
brosato
0

Comments

1 comment

Sort by
  • petey
    If you provide an explicit file name in the COPYTO option, all the backup files will be copied to the same folder. If you want the files to be copied to different locations depending on the backup attributes, you can use tags to specify the locations. E.g.
    EXEC master..sqlbackup '-sql "BACKUP ... WITH COPYTO = ''\\fileserver\backups\<DATABASE>\'' ..." '

    See here for details on the available tags.
    petey
    0

Add comment

Please sign in to leave a comment.