Categories
Sql Server

Striped Backup In SQL Server

Striped Backup In SQL Server

When databases are so large that creating a full backup on a single tape or disk
is impossible.In these instances, you can use striped backups.Striping your backups has the potential to dramatically shorten the time it takes for your backups to complete.

You can stripe your backup using either SQL Server Management Studio or T-SQL.In SSMS, simply right-click on the name of the database and then select ‘Tasks’, followed by ‘Back Up…’ as shown here:

12-19-2013 8-56-08 PM

T-SQL

BACKUP DATABASE DEV TO DISK='A:\DEV1.BAK', DISK='G:\DEV2.BAK', DISK='H:\DEV3.BAK'
WITH INIT, CHECKSUM, CONTINUE_ON_ERROR