16. Backup to multiple locations at the same time (Mirror Backups)
Sometimes it can be useful to have two or more copies of the same backup. So let's explain how to take back up for two or more locations at once in this video
Script :
BACKUP DATABASE DB_NAME
TO DISK = 'DISK_PATH'
MIRROR TO DISK = 'DISK_PATH'
MIRROR TO DISK = 'DISK_PATH'
WITH FORMAT, COMPRESSION, STATS
