TSQL Tutorial

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).