Copy to network and multiple folders

brosato

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?

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.