asked
MS SQL full database backup multiplexing?
How to split full database backup in multiple backup files on multiple physical disk?
You can split a backup over multiple files either as stripes..... [BOL example][1] > `BACKUP DATABASE AdventureWorks2008R2 TO DISK='X:\SQLServerBackups\AdventureWorks2008R2_1.bak', DISK='Y:\SQLServerBackups\AdventureWorks2008R2_2.bak', DISK='Z:\SQLServerBackups\AdventureWorks2008R2_3.bak' WITH FORMAT, MEDIANAME = 'AdventureWorks2008R2StripedSet0', MEDIADESCRIPTION = 'Striped media set for AdventureWorks2008R2 database; GO` or as mirror ... [BOL example][2] >`BACKUP DATABASE AdventureWorks2008R2 TO DISK='X:\SQLServerBackups\AdventureWorks2008R2_1a.bak', DISK='Y:\SQLServerBackups\AdventureWorks2008R2_2a.bak', DISK='Z:\SQLServerBackups\AdventureWorks2008R2_3a.bak' MIRROR TO DISK='X:\SQLServerBackups\AdventureWorks2008R2_1b.bak', DISK='Y:\SQLServerBackups\AdventureWorks2008R2_2b.bak', DISK='Z:\SQLServerBackups\AdventureWorks2008R2_3b.bak'; GO` [1]:
http://msdn.microsoft.com/en-us/library/ms186865.aspx [2]:
http://msdn.microsoft.com/en-us/library/ms186865.aspx
`RESTORE DATABASE AdventureWorks2008R2 FROM DISK='X:\SQLServerBackups\AdventureWorks2008R2_1.bak', DISK='Y:\SQLServerBackups\AdventureWorks2008R2_2.bak', DISK='Z:\SQLServerBackups\AdventureWorks2008R2_3.bak'`
The same as if you lost your single backup file: go to the off-site copy, or recover from SAN/tape/whatever your backup strategy is
