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!–

http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/sqlbackuprest.mspx and check BOL too for BACKUP statement topic. Satya SKJ
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
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’,
disk=’c:2.bak’,
disk=’c:3.bak’
Rajeev Kumar Srivastava
–ALWAYS BE POSITIVE!–

When restoring you need to specify those three files Madhivanan Failing to plan is Planning to fail

]]>