December 16, 2009 at 10:29 pm
how do you backup to multiple backup devices at the same time?
could you post some examples.
December 17, 2009 at 5:16 am
think you cant backup to multiple devices at a time.
You can take backup to multiple locations or drives in a device.
backup database db_name to disk=''path1,
disk=path2,
disk=path3,
disk=path4
December 17, 2009 at 5:33 am
Ratheesh.K.Nair (12/17/2009)
think you cant backup to multiple devices at a time.You can take backup to multiple locations or drives in a device.
backup database db_name to disk=''path1,
disk=path2,
disk=path3,
disk=path4
This would create stripped backup across those paths and all backup subsets would be required during restore.
To create a backup to multiple devices, use MIRROR TO clause
Backup database mydb to disk='c:\path1\dbbackup1.bak' MIRROR TO disk='c:\path2\dbbackup2.bak' WITH FORMAT
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply