Stripe backups | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Stripe backups

SQL Server 2000 provides the ability to stripe backups across multiple tapes or disk devices. Does any one know the syntax for the same? Rajeev Kumar Srivastava
–ALWAYS BE POSITIVE!– and check BOL too for BACKUP statement topic. Satya SKJ
Contributing Editor & Forums Moderator
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
–Here is syntax to take multiple stripe backup:-
–This is an example for 3 stripe:- Backup Database ABC
to disk=’c:1.bak’,
Rajeev Kumar Srivastava
When restoring you need to specify those three files Madhivanan Failing to plan is Planning to fail