SQL Server with Rick Martinez

Feb 2 2010   9:42PM GMT

SQL SERVER 2005 Striping Backup Sets

Rick Martinez Rick Martinez Profile: Rick Martinez

Striping backups involves using more than one device (disk or tape) for a single backup set operation. When performing a database backup, you can use up to 64 devices (disk or backup) in your backup operation. This is particularly useful for very large databases, because you can enhance backup performance by striping the backup files across seperate drives. Striping the backup files means each file is written simultaneously. Striped backups use parallel write operations, and can significantly speed up backup operations.
Here is a sample:

TO DISK = 'C:\Backup\AdventureWorks_Stripe1.bak',
DISK = 'D:\Backup\AdventureWorks_Stripe2.bak',
DISK = 'E:\Backup\AdventureWorks_Stripe3.bak'

This creates three files which are each used to store one third of the backup information needed to restore the database.

 Comment on this Post

There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when other members comment.

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

Share this item with your network: