Hi
how to backup a single db on multiple files to split into smaller files .
Regards
AjayBACKUP DATABASE northwind TO
DISK = 'c:\bkp\backup_1.BAK' ,
DISK = 'c:\bkp\backup_2.BAK' ,
DISK = 'c:\bkp\backup_3.BAK'
This will stripe the backup across all these files.
However, all devices must be of the same type ex : disk,
tape etc.
- Vishal
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment