Backup database devices in a Striped Media Set
The following example backup the model database devices in a striped media set.
Example:
BACKUP DATABASE model
TO DISK='E:\SQLServerBackup\1\model_1.bak',
DISK='E:\SQLServerBackup\2\model_2.bak'
WITH FORMAT,
MEDIANAME = 'modelStripedSet0',
MEDIADESCRIPTION = 'Striped media set for model database';
GO
| Messages: |
|---|
| Processed 328 pages for database 'model', file 'modeldev' on file 1. |
| Processed 2 pages for database 'model', file 'modellog' on file 1. |
| BACKUP DATABASE successfully processed 330 pages in 0.350 seconds (7.345 MB/sec). |
